RMA_PRMCD_VW

(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.DESCR , A.SETID , M.MERCH_TYPE , S.TD_RETURN_DAYS , D.LAST_ORDER_DATE FROM PS_BUS_UNIT_TBL_FS U , PS_PPRC_PROMO_TBL A , PS_TD_SETID_TBL S , PS_SET_CNTRL_REC SA , PS_TD_PRO_CUST_PRI G , PS_TD_PROMO_CUST D , PS_TD_PRO_MERC_CUS J , PS_TD_MERCH_TYP_VW M WHERE SA.RECNAME = 'PPRC_PROMO_TBL' AND SA.SETCNTRLVALUE = U.BUSINESS_UNIT AND SA.SETID = A.SETID AND S.SETID = A.SETID AND S.RETURN_FLAG = 'Y' AND A.EFF_STATUS = 'A' AND A.SETID = D.SETID AND A.PPRC_PROMO_CD = D.PPRC_PROMO_CD AND D.STATUS_TD = 'CA' AND G.SETID = D.SETID AND G.PPRC_PROMO_CD = D.PPRC_PROMO_CD AND G.CUST_ID = D.CUST_ID AND J.SETID = D.SETID AND J.PPRC_PROMO_CD = D.PPRC_PROMO_CD AND J.EOEP_RULE_ID <> ' ' AND J.TD_ADJUST_TYPE <> 'LS' AND J.RETURN_FLAG = 'Y' AND M.SETID = J.SETID AND M.MERCH_TYPE = J.MERCH_TYPE AND M.MERCH_ACTIVITY = 'P' UNION SELECT DISTINCT U.BUSINESS_UNIT , D.CUST_ID , K.FG_PRODUCT_ID , A.PPRC_PROMO_CD , A.DESCR , A.SETID , M.MERCH_TYPE , S.TD_RETURN_DAYS , D.LAST_ORDER_DATE FROM PS_BUS_UNIT_TBL_FS U , PS_PPRC_PROMO_TBL A , PS_TD_SETID_TBL S , PS_SET_CNTRL_REC SA , PS_TD_PROMO_CUST D , PS_TD_PRO_MERC_CUS J , PS_TD_MERCH_TYP_VW M , PS_TD_PRO_MERBRK_C K WHERE SA.RECNAME = 'PPRC_PROMO_TBL' AND SA.SETCNTRLVALUE = U.BUSINESS_UNIT AND SA.SETID = A.SETID AND S.SETID = A.SETID AND S.RETURN_FLAG = 'Y' AND A.EFF_STATUS = 'A' AND A.SETID = D.SETID AND A.PPRC_PROMO_CD = D.PPRC_PROMO_CD AND D.STATUS_TD = 'CA' AND K.SETID = D.SETID AND K.PPRC_PROMO_CD = D.PPRC_PROMO_CD AND K.CUST_ID = D.CUST_ID AND J.MERCH_TYPE = K.MERCH_TYPE AND J.EOEP_ACTION_TYPE = '3' AND J.SETID = D.SETID AND J.PPRC_PROMO_CD = D.PPRC_PROMO_CD AND J.EOEP_RULE_ID <> ' ' AND J.TD_ADJUST_TYPE <> 'LS' AND J.RETURN_FLAG = 'Y' AND M.SETID = J.SETID AND M.MERCH_TYPE = J.MERCH_TYPE AND M.MERCH_ACTIVITY = 'P' UNION SELECT DISTINCT U.BUSINESS_UNIT , E.CUST_ID , G.PRODUCT_ID , A.PPRC_PROMO_CD , A.DESCR , A.SETID , H.EOEP_ADJUST_TYPE , S.TD_RETURN_DAYS , A.LAST_ORDER_DATE FROM PS_BUS_UNIT_TBL_FS U , PS_PPRC_PROMO_TBL A , PS_TD_SETID_TBL S , PS_SET_CNTRL_REC SA , PS_TD_ALLOW_CUS_VW E , PS_TD_PROMO_PROD G , PS_TD_ALLOW_DISCNT H WHERE SA.RECNAME = 'PPRC_PROMO_TBL' AND SA.SETCNTRLVALUE = U.BUSINESS_UNIT AND SA.SETID = A.SETID AND S.SETID = A.SETID AND S.RETURN_FLAG = 'Y' AND A.EFF_STATUS = 'A' 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 AND A.SETID = H.SETID AND A.PPRC_PROMO_CD = H.PPRC_PROMO_CD AND H.EOEP_RULE_ID <> ' ' AND H.RETURN_FLAG = 'Y' AND A.ALLOW_STATUS = '4' UNION SELECT DISTINCT U.BUSINESS_UNIT , E.CUST_ID , G.FG_PRODUCT_ID , A.PPRC_PROMO_CD , A.DESCR , A.SETID , H.EOEP_ADJUST_TYPE , S.TD_RETURN_DAYS , A.LAST_ORDER_DATE FROM PS_BUS_UNIT_TBL_FS U , PS_PPRC_PROMO_TBL A , PS_TD_SETID_TBL S , PS_SET_CNTRL_REC SA , PS_TD_ALLOW_CUS_VW E , PS_TD_ALLOW_BREAK G , PS_TD_ALLOW_DISCNT H WHERE SA.RECNAME = 'PPRC_PROMO_TBL' AND SA.SETCNTRLVALUE = U.BUSINESS_UNIT AND SA.SETID = A.SETID AND S.SETID = A.SETID AND S.RETURN_FLAG = 'Y' AND A.EFF_STATUS = 'A' 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 AND A.SETID = H.SETID AND A.PPRC_PROMO_CD = H.PPRC_PROMO_CD AND H.EOEP_RULE_ID <> ' ' AND H.RETURN_FLAG = 'Y' AND A.ALLOW_STATUS = '4' AND H.EOEP_ACTION_TYPE = '3'

  • Related Language Record: RMA_PRMCD_LVW

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 SETID_PROMO Character(5) VARCHAR2(5) NOT NULL Promotion SetID
    7 MERCH_TYPE Character(10) VARCHAR2(10) NOT NULL Merchandising Type
    8 TD_RETURN_DAYS Number(3,0) SMALLINT NOT NULL Days to Accept Returns
    9 LAST_ORDER_DATE Date(10) DATE Last Order Date