RG_AFFCTG_PARTY

(SQL View)
 Index Back

Affected Parties by Group

Affected parties when product group is selected

SELECT DISTINCT A.SETID , A.PRODUCT_GROUP , A.PRODUCT_ID , B.DESCR , C.BO_ID_CONTACT , C.ROLE_TYPE_ID_CNTCT , E.BO_NAME_DISPLAY , C.SERIAL_ID , C.ASSETTAG , C.INSTALLED_DATE , H.DESCR FROM PS_PROD_PGRP_LNK A , PS_PROD_ITEM B , PS_RF_INST_PROD C , PS_BO_NAME E , PS_RD_PERSON F , PS_RB_WORKER G , PS_DEPT_TBL H WHERE A.SETID = B.SETID AND A.PRODUCT_ID = B.PRODUCT_ID AND B.SETID = C.SETID AND B.PRODUCT_ID = C.PRODUCT_ID AND C.BO_ID_CONTACT = E.BO_ID AND C.ROLE_TYPE_ID_CNTCT = 4 AND F.BO_ID = C.BO_ID_CONTACT AND G.PERSON_ID = F.PERSON_ID AND G.SETID_DEPT = H.SETID (+) AND G.DEPTID = H.DEPTID (+) AND E.PRIMARY_IND = 'Y'

  • Related Language Record: RG_PROD_GRP_VWL

    • # 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.
    2 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL PRoduct Group
    3 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 BO_ID_CNTCT Number(31,0) DECIMAL(31) NOT NULL This field represents the business object ID for a Contact
    6 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
    7 CNTCT_NAME80 Character(80) VARCHAR2(80) NOT NULL Contact Name length to match with business object name display
    8 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the Serial ID of an item or installed product
    9 ASSETTAG Character(40) VARCHAR2(40) NOT NULL Asset Tag
    10 INSTALLED_DATE Date(10) DATE Field used for storing Installed Date of Installed product
    11 DESCR_DEPT Character(30) VARCHAR2(30) NOT NULL Description