/* mmt 05/18/04 Data model changes */

DMD_SRL_ALC_VW2

(SQL View)
 Index Back

SELECT DISTINCT C.BUSINESS_UNIT , C.DEMAND_SOURCE , C.SOURCE_BUS_UNIT , C.ORDER_NO , C.ORDER_INT_LINE_NO , C.SCHED_LINE_NBR , C.INV_ITEM_ID , C.DEMAND_LINE_NO , A.STORAGE_AREA , A.STOR_LEVEL_1 , A.STOR_LEVEL_2 , A.STOR_LEVEL_3 , A.STOR_LEVEL_4 , A.CONTAINER_ID , A.STAGED_DATE , A.INV_LOT_ID , A.SERIAL_ID , A.UNIT_OF_MEASURE FROM PS_PHYSICAL_INV A , PS_LOT_ALLOC_INV B , PS_DEMAND_PHYS_INV C , PS_IN_DEMAND D WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT AND %Join(COMMON_KEYS, DEMAND_PHYS_INV C, IN_DEMAND D) AND A.STAGED_DATE = C.STAGED_DATE AND A.INV_LOT_ID = C.INV_LOT_ID AND A.INV_ITEM_ID = C.INV_ITEM_ID AND A.SERIAL_ID = C.SERIAL_ID AND A.STORAGE_AREA = C.STORAGE_AREA AND A.STOR_LEVEL_1 = C.STOR_LEVEL_1 AND A.STOR_LEVEL_2 = C.STOR_LEVEL_2 AND A.STOR_LEVEL_3 = C.STOR_LEVEL_3 AND A.STOR_LEVEL_4 = C.STOR_LEVEL_4 AND A.CONTAINER_ID = C.CONTAINER_ID AND A.UNIT_OF_MEASURE = C.UNIT_MEASURE_PICK AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.DEMAND_SOURCE = C.DEMAND_SOURCE AND B.SOURCE_BUS_UNIT = C.SOURCE_BUS_UNIT AND B.ORDER_NO = C.ORDER_NO AND B.ORDER_INT_LINE_NO = C.ORDER_INT_LINE_NO AND B.SCHED_LINE_NBR = C.SCHED_LINE_NBR AND B.INV_ITEM_ID = C.INV_ITEM_ID AND B.DEMAND_LINE_NO = C.DEMAND_LINE_NO AND C.QTY_BASE > 0 AND D.IN_FULFILL_STATE <> '70' AND (A.AVAIL_STATUS = '1' OR A.AVAIL_STATUS = '2')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
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

Default Value: DEMAND_PICK_VW.INV_ITEM_ID

8 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
9 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area

Prompt Table: %EDITTABLE2

10 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1

Prompt Table: %EDITTABLE3

11 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2

Prompt Table: %EDITTABLE4

12 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3

Prompt Table: %EDITTABLE5

13 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4

Prompt Table: %EDITTABLE6

14 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID

Prompt Table: %EDITTABLE8

15 STAGED_DATE Date(10) DATE Staged Date

Prompt Table: %EDITTABLE9

16 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID

Prompt Table: %EDITTABLE

17 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID

Prompt Table: %EDITTABLE7

18 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage