OM_ADJUST_LVW

(SQL View)
 Index Back

OM_ADJUST Worksheet Vw

Date Init Issue Description 102604 JJM F-CJORG-L1CX3 Sprinklebacks - Margin Adjustments

SELECT OH.BUSINESS_UNIT , OH.ORDER_NO , OL.ORDER_INT_LINE_NO , OS.SCHED_LINE_NBR , LANG.LANGUAGE_CD , LANG.NAME1 FROM PS_ORD_HEADER OH , PS_ORD_LINE OL , PS_ORD_SCHEDULE OS , PS_CUSTOMER_LANG LANG WHERE %Join(COMMON_KEYS, ORD_HEADER OH , ORD_LINE OL) AND %Join(COMMON_KEYS, ORD_LINE OL, ORD_SCHEDULE OS) AND LANG.CUST_ID = OH.SOLD_TO_CUST_ID AND LANG.SETID = ( SELECT SCR.SETID FROM PS_SET_CNTRL_REC SCR WHERE SCR.SETCNTRLVALUE = OH.BUSINESS_UNIT AND SCR.RECNAME = 'CUSTOMER')

  • Related Language Record for OM_ADJUST_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
    3 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
    4 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 CUST_NAME Character(40) VARCHAR2(40) NOT NULL Name