SCN_HDRCIDV_LNG

(SQL View)
 Index Back

Sales Cntrct by SoldTo Vw RLR

Date Init. Issue # Description 040103 JJM 58069000 Created table for prompting

SELECT DISTINCT D.BUSINESS_UNIT , C.SOLD_TO_CUST_ID , CL.LANGUAGE_CD , CL.NAME1 , AL.DESCR FROM PS_SET_CNTRL_REC SC , PS_SCON_HDR A , PS_SCON_HDR_LNG AL , PS_SCON_LINE B , PS_SCON_CUST_CGRP C , PS_SCON_PROD_PGRP D , PS_CUSTOMER_LANG CL WHERE A.SETID = AL.SETID AND A.CNTRCT_ID = AL.CNTRCT_ID AND 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 CL.SETID = SC.SETID AND CL.CUST_ID = C.SOLD_TO_CUST_ID

  • Related Language Record for SCN_HDR_CID_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
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description