RMA_CSHPHSVWLNG

(SQL View)
 Index Back

RMA Cust ship hist RL view

This is the related language view for RMA_CUSSHPHS_VW and RMA_MSRSHPHS_VW. Date Initials Issue # Description 052504 twh F-KNANN-V59N4 Replace demand table references with IN_DEMAND

SELECT DISTINCT S.SOURCE_BUS_UNIT , OH.SOLD_TO_CUST_ID , P.LANGUAGE_CD , P.DESCR FROM PS_IN_DEMAND S , PS_ORD_HEADER OH , PS_SET_CNTRL_REC SC , PS_PROD_ITEM_LNG P WHERE S.SOURCE_BUS_UNIT = OH.BUSINESS_UNIT AND S.ORDER_NO = OH.ORDER_NO AND S.DEMAND_SOURCE = 'OM' AND SC.SETCNTRLVALUE = OH.BUSINESS_UNIT AND SC.RECNAME = 'PROD_ITEM_LNG' AND P.SETID = SC.SETID AND P.PRODUCT_ID = S.PRODUCT_ID

  • Related Language Record for RMA_BIINVHS_VW RMA_CUSSHPHS_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_OM.BUSINESS_UNIT

    2 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description