RB_PRDRELDS_VWL

(SQL View)
 Index Back

Relationship Descr View

this is used in product relationship for product data model

SELECT A.SETID , A.PRODUCT_ID , A.PRODUCT_ID_ALT , A.PROD_REL_TYPE , A.START_DT , A.END_DT , D.LANGUAGE_CD , D.DESCR , E.DESCR FROM PS_PROD_RELATIONS A , PS_PROD_ITEM_LNG D , PS_RB_RELATION_LNG E WHERE A.PROD_REL_TYPE=A.PROD_REL_TYPE AND A.SETID = D.SETID AND A.PRODUCT_ID = D.PRODUCT_ID AND A.PROD_REL_TYPE = E.PROD_REL_TYPE AND D.LANGUAGE_CD = E.LANGUAGE_CD

  • Related Language Record for RB_PRDRELDSC_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Default Value: PROD_ITEM.SETID

    2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    3 PRODUCT_ID_ALT Character(18) VARCHAR2(18) NOT NULL Product ID Alternate

    Prompt Table: PRODREL_SRCH_VW

    4 PROD_REL_TYPE Character(5) VARCHAR2(5) NOT NULL Product Relationship Type

    Prompt Table: RB_RELATIONS

    5 START_DT Date(10) DATE Start date field to store start date value.

    Default Value: %date

    6 END_DT Date(10) DATE This field stores the end date values.
    7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 PRODUCT_DESCR Character(30) VARCHAR2(30) NOT NULL Product Description
    9 RELATIONSHIP_DESCR Character(254) VARCHAR2(254) NOT NULL Relationship Description