TD_PRMCDACC_LNG

(SQL View)
 Index Back

View of Accepted Promos/Alws


SELECT DISTINCT A.SETID , B.CUST_ID , F.PRODUCT_ID , A.PPRC_PROMO_CD , D.LANGUAGE_CD , D.DESCR FROM PS_PPRC_PROMO_TBL A , PS_CUSTOMER B , PS_SET_CNTRL_REC C , PS_PROD_ITEM F , PS_TD_PPRC_DATE_VW I , PS_PPRC_PROTBL_LNG D WHERE A.EFF_STATUS = 'A' AND C.RECNAME = 'PPRC_PROMO_TBL' AND A.SETID = D.SETID AND A.PPRC_PROMO_CD = D.PPRC_PROMO_CD AND C.SETCNTRLVALUE = B.SETID AND A.PPRC_PROMO_CD = I.PPRC_PROMO_CD AND ((EXISTS( SELECT 'X' FROM PS_TD_PRO_CUST_PRI G , PS_TD_PROMO_CUST D , PS_TD_PRO_MERC_CUS J WHERE A.SETID = D.SETID AND A.PPRC_PROMO_CD = D.PPRC_PROMO_CD AND B.CUST_ID = D.CUST_ID AND F.PRODUCT_ID = G.PRODUCT_ID AND D.STATUS_TD = 'CA' AND G.SETID = D.SETID AND G.PPRC_PROMO_CD = D.PPRC_PROMO_CD AND I.PPRC_PROMO_CD = D.PPRC_PROMO_CD AND J.SETID = D.SETID AND J.PPRC_PROMO_CD = D.PPRC_PROMO_CD AND J.EOEP_RULE_ID = I.EOEP_RULE_ID AND G.CUST_ID = D.CUST_ID)) OR (EXISTS( SELECT 'X' FROM PS_TD_ALLOW_CUS_VW E , PS_TD_PROMO_PROD G , PS_TD_ALLOW_DISCNT H WHERE A.SETID = E.SETID AND A.PPRC_PROMO_CD = E.PPRC_PROMO_CD AND B.CUST_ID = E.CUST_ID AND E.SETID = G.SETID AND E.PPRC_PROMO_CD = G.PPRC_PROMO_CD AND G.PRODUCT_ID = F.PRODUCT_ID AND A.SETID = H.SETID AND A.PPRC_PROMO_CD = H.PPRC_PROMO_CD AND I.PPRC_PROMO_CD = H.PPRC_PROMO_CD AND I.EOEP_RULE_ID = H.EOEP_RULE_ID AND A.ALLOW_STATUS = '4')))

  • Related Language Record for TD_PRMCD_ACC_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
    3 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    4 PPRC_PROMO_CD Character(20) VARCHAR2(20) NOT NULL Price Promotion Code

    Default Value: NEXT

    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description