IN_DELCNSRCH_VW

(SQL View)
Index Back

Delivery Ship Containers

View used to retrieve container data for deliveries

SELECT DETL.BUSINESS_UNIT , DETL.DEMAND_SOURCE , DETL.SOURCE_BUS_UNIT , DETL.ORDER_NO , DETL.ORDER_INT_LINE_NO , DETL.SCHED_LINE_NBR , DETL.INV_ITEM_ID , DETL.DEMAND_LINE_NO , OUTR.OUTER_MOST_CNTR_ID , DETL.SHIP_CNTR_ID FROM PS_SHIP_CNTR_HDR INNR , PS_SHIP_CNTR_HDR OUTR , PS_SHIP_CNTR_INV DETL , PS_IN_DEMAND D WHERE OUTR.BUSINESS_UNIT = INNR.BUSINESS_UNIT AND OUTR.OUTER_MOST_CNTR_ID = INNR.SHIP_CNTR_ID AND %Join(COMMON_KEYS, SHIP_CNTR_HDR OUTR, SHIP_CNTR_INV DETL) AND %Join(COMMON_KEYS, IN_DEMAND D, SHIP_CNTR_INV DETL)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BUIN_NONVW

2 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
3 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
4 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
5 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
6 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
8 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
9 SHIP_CNTR_ID Character(20) VARCHAR2(20) NOT NULL Shipping Container ID

Prompt Table: SHIP_CNTR_HDR

10 CHILD_SHIP_CNTR Character(20) VARCHAR2(20) NOT NULL Child Shipping Container ID