RO_PK_PPGM_LVW

(SQL View)
 Index Back

Pricing Partner Program RLR

This view lists the partner programs available for pricing.

SELECT A.SETID , A.PARTNER_PGM_ID , B.LANGUAGE_CD , B.PARTNER_PGM_NAME FROM PS_RD_PR_PROG A , PS_RD_PR_PROG_LNG B WHERE A.SETID = B.SETID AND A.PARTNER_PGM_ID = B.PARTNER_PGM_ID AND A.PARTNER_PGM_STATUS = 'A'

  • Related Language Record for RO_PK_PPGM_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: OPR_DEF_TBL_RB.SETID

    Prompt Table: SP_SETID_NONVW

    2 PARTNER_PGM_ID Character(15) VARCHAR2(15) NOT NULL Partner Program ID

    Default Value: NEXT

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 EOEP_CHAR Character(254) VARCHAR2(254) NOT NULL Long field