RMA_PRMCD_LVW

(SQL View)
 Index Back

RMA Promo Code View

RMA Promo Code View

SELECT DISTINCT U.BUSINESS_UNIT , D.CUST_ID , G.PRODUCT_ID , A.PPRC_PROMO_CD , A.LANGUAGE_CD , A.DESCR FROM PS_BUS_UNIT_TBL_FS U , PS_PPRC_PROTBL_LNG A , PS_SET_CNTRL_REC SA , PS_TD_PRO_CUST_PRI G , PS_TD_PROMO_CUST D WHERE SA.RECNAME = 'PPRC_PROMO_TBL' AND SA.SETCNTRLVALUE = U.BUSINESS_UNIT AND SA.SETID = A.SETID AND A.SETID = D.SETID AND A.PPRC_PROMO_CD = D.PPRC_PROMO_CD AND G.SETID = D.SETID AND G.PPRC_PROMO_CD = D.PPRC_PROMO_CD AND G.CUST_ID = D.CUST_ID UNION SELECT DISTINCT U.BUSINESS_UNIT , E.CUST_ID , G.PRODUCT_ID , A.PPRC_PROMO_CD , A.LANGUAGE_CD , A.DESCR FROM PS_BUS_UNIT_TBL_FS U , PS_PPRC_PROTBL_LNG A , PS_SET_CNTRL_REC SA , PS_TD_ALLOW_CUS_VW E , PS_TD_PROMO_PROD G WHERE SA.RECNAME = 'PPRC_PROMO_TBL' AND SA.SETCNTRLVALUE = U.BUSINESS_UNIT AND SA.SETID = A.SETID AND A.SETID = E.SETID AND A.PPRC_PROMO_CD = E.PPRC_PROMO_CD AND E.SETID = G.SETID AND E.PPRC_PROMO_CD = G.PPRC_PROMO_CD

  • Related Language Record for RMA_PRMCD_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

    Prompt Table: %EDITTABLE5

    3 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    4 PPRC_PROMO_CD Character(20) VARCHAR2(20) NOT NULL Price Promotion Code

    Prompt Table: PPRC_PROMO_TBL
    Set Control Field: BUSINESS_UNIT

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