RF_PTNR_SRCH_VW

(SQL View)
 Index Back

Installed Product Partner View

Prompt View for Installed Product Partner Company

SELECT B.BO_NAME , A.BO_ID , B.BO_NAME_UPPER , B.BO_NAME_AC , A.DUNS_NUMBER , C.PARTNER_STATUS , A.COMPANYID , A.SETID , A.SYNCID , D.PARTNER_PGM_ID , E.PARTNER_PGM_NAME FROM PS_RD_COMPANY A , PS_BO_NAME B , PS_RD_PARTNER C , PS_RD_PR_PGM D , PS_RD_PR_PROG E WHERE A.BO_ID = B.BO_ID AND A.BO_ID = C.BO_ID AND A.BO_ID = D.BO_ID AND B.PRIMARY_IND = 'Y' AND D.PRIMARY_IND = 'Y' AND D.PARTNER_PGM_ID = E.PARTNER_PGM_ID AND C.PARTNER_STATUS = '1'

  • Parent record: BO

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
    2 BO_ID_PTNR_CMP Signed Number(32,0) DECIMAL(31) NOT NULL Partner Company Business Object ID.
    3 BO_NAME_UPPER Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
    4 BO_NAME_AC Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
    5 DUNS_NUMBER Character(20) VARCHAR2(20) NOT NULL DUNS Number
    6 PARTNER_STATUS Character(1) VARCHAR2(1) NOT NULL Parnter Status
    1=Active
    2=Approved
    3=Rejected
    4=Pending Approval
    5=Inactive
    7 COMPANYID Character(15) VARCHAR2(15) NOT NULL Company ID
    8 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
    9 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    10 PARTNER_PGM_ID Character(15) VARCHAR2(15) NOT NULL Partner Program ID
    11 PARTNER_PGM_NAME Character(50) VARCHAR2(50) NOT NULL Partner Program name