SCN_HDRCSTV_LNG

(SQL View)
 Index Back

Sales Cntrct by SoldTo Vw RLR

Date Init. Issue # Description 01/03/01 JJM R-SGATIG-ZV65C Changed SQL to use new tables

SELECT DISTINCT D.BUSINESS_UNIT , C.SOLD_TO_CUST_ID , L.LANGUAGE_CD , L.NAME1 FROM PS_SET_CNTRL_REC SC , PS_SCON_HDR A , PS_SCON_LINE B , PS_SCON_CUST_CGRP C , PS_SCON_PROD_PGRP D , PS_CUSTOMER_LANG L WHERE A.SETID = B.SETID AND A.CNTRCT_ID = B.CNTRCT_ID AND B.SETID = C.SETID AND B.CNTRCT_ID = C.CNTRCT_ID AND C.SETID = D.SETID AND C.CNTRCT_ID = D.CNTRCT_ID AND B.LINE_NBR = D.LINE_NBR AND A.SCON_STATUS = 'A' AND B.UNIT_OF_MEASURE <> ' ' AND SC.RECNAME = 'CUSTOMER' AND SC.SETCNTRLVALUE = D.BUSINESS_UNIT AND L.SETID = SC.SETID AND L.CUST_ID = C.SOLD_TO_CUST_ID

  • Related Language Record for SCN_HDR_CUST_VW SCN_HDR_PRD_VW SCN_HDR_SLD_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
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1