PL_PI_SHIPTO_VW

(SQL View)
 Index Back

PL Ship To View

02/20/03 JC (CN#PL880-1): Added Related Language View

SELECT DISTINCT A.PROBINST , A.SETID , A.SHIP_TO_CUST_ID , B.NAME1 , B.NAMESHORT FROM PS_PL_ORD_SCHEDULE A , PS_CUSTOMER B , PS_SET_CNTRL_REC C , PS_MASTER_ITEM_TBL D WHERE (A.SETID <> ' ' AND A.SHIP_TO_CUST_ID = B.CUST_ID AND C.SETID = D.SETID AND C.SETID = A.SETID AND C.RECNAME = 'MASTER_ITEM_TBL' AND C.SETCNTRLVALUE = A.SHIP_FROM_BU AND D.INV_ITEM_ID = A.INV_ITEM_ID) OR (A.BUSINESS_UNIT <> ' ' AND A.SHIP_TO_CUST_ID = B.CUST_ID AND C.SETID = D.SETID AND C.RECNAME = 'MASTER_ITEM_TBL' AND C.SETCNTRLVALUE = A.BUSINESS_UNIT AND D.INV_ITEM_ID = A.INV_ITEM_ID)

  • Related Language Record: PL_PI_SHIPTOLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
    2 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID
    3 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
    4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    5 NAMESHORT Character(10) VARCHAR2(10) NOT NULL Short Name