TD_PROMO_MAS_VW

(SQL View)
 Index Back

List of template promotions


SELECT DISTINCT A.OPRID , c.SETID , C.PPRC_PROMO_CD , E.DESCR , E.DESCRSHORT FROM PS_TD_APPR_NODE_VW A , PS_TD_PROMO_CUST C , PS_TD_SETID_TBL D , PS_PPRC_PROMO_TBL E , PS_SET_CNTRL_REC F WHERE C.SETID = F.SETCNTRLVALUE AND F.RECNAME = 'CUSTOMER' AND F.SETID = A.SETID AND A.CUST_ID = C.CUST_ID AND A.TD_TREE_ID = D.TD_TREE_ID_CUST AND D.SETID = C.SETID AND C.SETID = E.SETID AND C.PPRC_PROMO_CD = E.PPRC_PROMO_CD AND E.TEMPLATE_FLAG = 'T'

  • Related Language Record: TD_PROMO_LNG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETTD_NONVW

    3 PPRC_PROMO_CD Character(20) VARCHAR2(20) NOT NULL Price Promotion Code

    Default Value: NEXT

    Prompt Table: TD_PROM_AUTO_VW

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description