RMA_MERTYPE_LVW

(SQL View)
 Index Back

RMA Merch Type View

RMA Merch Type View

SELECT U.BUSINESS_UNIT , P.PPRC_PROMO_CD , P.MERCH_TYPE , M.LANGUAGE_CD , M.DESCR FROM PS_BUS_UNIT_TBL_FS U , PS_TD_PRO_MERC_CUS P , PS_TD_MRCH_TYP_LNG M , PS_SET_CNTRL_REC SA WHERE SA.RECNAME = 'PPRC_PROMO_TBL' AND SA.SETCNTRLVALUE = U.BUSINESS_UNIT AND SA.SETID = P.SETID AND P.SETID = M.SETID AND P.MERCH_TYPE = M.MERCH_TYPE AND P.EOEP_RULE_ID <> ' ' AND P.TD_ADJUST_TYPE <> 'LS'

  • Related Language Record for RMA_MERTYPE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 PPRC_PROMO_CD Character(20) VARCHAR2(20) NOT NULL Price Promotion Code

    Prompt Table: PPRC_PROMO_TBL
    Set Control Field: BUSINESS_UNIT

    3 MERCH_TYPE Character(10) VARCHAR2(10) NOT NULL Merchandising Type

    Prompt Table: TD_MERCH_TYPE
    Set Control Field: BUSINESS_UNIT

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