BO_REL_VW

(SQL View)
 Index Back

Bus Object Relationship Instan

An instance of a relationship between Business Objects

SELECT A.BO_ID , B.REL_TYPE_ID , B.BO_ID_1 , B.ROLE_TYPE_ID_1 , B.BO_ID_2 , B.ROLE_TYPE_ID_2 , B.START_DT ,CASE WHEN B.END_DT > %CurrentDateIn THEN 'A' ELSE 'I' END , C.DESCR , B.START_DT , B.END_DT , B.BO_REL_ID , B.ROW_LASTMANT_OPRID , B.ROW_LASTMANT_DTTM FROM PS_BO A , PS_BO_REL B , PS_BO_REL_TYPE C WHERE (A.BO_ID = B.BO_ID_1 OR A.BO_ID=B.BO_ID_2) AND B.REL_TYPE_ID = C.REL_TYPE_ID AND C.PUBLISH_FLAG = 'Y'

  • Related Language Record: BO_REL_VW_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
    2 REL_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Relationship Type ID

    Prompt Table: BO_REL_TYPE

    3 BO_ID_1 Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID 1
    4 ROLE_TYPE_ID_1 Number(12,0) DECIMAL(12) NOT NULL Role Type ID
    5 BO_ID_2 Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID 2

    Prompt Table: BO

    6 ROLE_TYPE_ID_2 Number(12,0) DECIMAL(12) NOT NULL Role Type ID

    Prompt Table: RB_VALID_ROLTYP

    7 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    8 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    10 START_DT Date(10) DATE Start date field to store start date value.
    11 END_DT Date(10) DATE This field stores the end date values.
    12 BO_REL_ID Signed Number(32,0) DECIMAL(31) NOT NULL Relationship ID of a Business Object
    13 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    14 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.