SHIP_CNTR_VW4

(SQL View)
 Index Back

Ship Cntr Order


SELECT DISTINCT A.BUSINESS_UNIT , A.SHIP_CNTR_ID , A.PARENT_SHIP_CNTR , A.OUTER_MOST_CNTR_ID , 'N' ,'N' , A.PRO_NUMBER , E.DEMAND_SOURCE , E.SOURCE_BUS_UNIT , E.ORDER_NO , A.CARRIER_ID FROM PS_SHIP_CNTR_HDR A , PS_SHIP_CNTR_HDR D , PS_SHIP_CNTR_INV E WHERE D.OUTER_MOST_CNTR_ID = A.SHIP_CNTR_ID AND D.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.BUSINESS_UNIT = E.BUSINESS_UNIT AND E.SHIP_CNTR_ID = D.SHIP_CNTR_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 SHIP_CNTR_ID Character(20) VARCHAR2(20) NOT NULL Shipping Container ID
3 PARENT_SHIP_CNTR Character(20) VARCHAR2(20) NOT NULL Parent Shipping Container ID
4 OUTER_MOST_CNTR_ID Character(20) VARCHAR2(20) NOT NULL Shipping Container ID
5 LOOSE_STOCK_FLAG Character(1) VARCHAR2(1) NOT NULL Loose Stock Present

Y/N Table Edit

Default Value: N

6 CHILDREN_CNTR_FLAG Character(1) VARCHAR2(1) NOT NULL Childern Containers Flag

Y/N Table Edit

Default Value: N

7 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number
8 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order
9 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
10 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
11 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID