IN_ALLOC_WBALVW

(SQL View)
 Index Back

SELECT DPI.BUSINESS_UNIT , DPI.DEMAND_SOURCE , DPI.SOURCE_BUS_UNIT , DPI.ORDER_NO , DPI.ORDER_INT_LINE_NO , DPI.SCHED_LINE_NBR , DPI.INV_ITEM_ID , DPI.DEMAND_LINE_NO , PI.STAGED_DATE , PI.INV_LOT_ID , PI.SERIAL_ID , PI.STORAGE_AREA , PI.STOR_LEVEL_1 , PI.STOR_LEVEL_2 , PI.STOR_LEVEL_3 , PI.STOR_LEVEL_4 , PI.CONTAINER_ID , PI.UNIT_OF_MEASURE , PI.QTY , PI.QTY_RESERVED , PI.QTY_BASE , PI.QTY_RESERVED_BASE , PI.AVAIL_STATUS , PI.AVAIL_STATUS_TYPE , (PI.QTY_BASE - PI.QTY_RESERVED_BASE) , (PI.QTY_BASE - PI.QTY_RESERVED_BASE) , DPI.QTY_PICKED , DPI.QTY_BASE , SL.NETTABLE_FLG , SL.NON_OWN_FLAG , SL.WIP_LOC_FLG , SL.PHYS_CYC_INV_FLG FROM PS_DEMAND_PHYS_INV DPI , PS_PHYSICAL_INV PI , PS_STOR_LOC_INV SL WHERE DPI.BUSINESS_UNIT = PI.BUSINESS_UNIT AND DPI.INV_ITEM_ID = PI.INV_ITEM_ID AND DPI.INV_LOT_ID = PI.INV_LOT_ID AND DPI.SERIAL_ID = PI.SERIAL_ID AND DPI.STORAGE_AREA = PI.STORAGE_AREA AND DPI.STOR_LEVEL_1 = PI.STOR_LEVEL_1 AND DPI.STOR_LEVEL_2 = PI.STOR_LEVEL_2 AND DPI.STOR_LEVEL_3 = PI.STOR_LEVEL_3 AND DPI.STOR_LEVEL_4 = PI.STOR_LEVEL_4 AND DPI.CONTAINER_ID = PI.CONTAINER_ID AND DPI.UNIT_MEASURE_PICK = PI.UNIT_OF_MEASURE AND (DPI.STAGED_DATE = PI.STAGED_DATE) AND %Join(COMMON_KEYS, PHYSICAL_INV PI, STOR_LOC_INV SL)

# 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

Prompt Table: BU_ITM_INV_VW

8 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
9 STAGED_DATE Date(10) DATE Staged Date

Default Value: %DATE

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

Default Value: INSTALLATION_IN.DFLT_INV_LOT_ID

Prompt Table: %EDIT_LOT_ID

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

Default Value: INSTALLATION_IN.DFLT_SERIAL_ID

12 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area

Prompt Table: STOR_AREA_VW2

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

Prompt Table: STOR_LEV1_VW2

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

Prompt Table: STOR_LEV2_VW2

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

Prompt Table: STOR_LEV3_VW2

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

Prompt Table: STOR_LEV4_VW2

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

Prompt Table: CNTR_ID_INV

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

Prompt Table: INV_STCK_UOM_VW

19 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
20 QTY_RESERVED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Reserved
21 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity
22 QTY_RESERVED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Reserved Base
23 AVAIL_STATUS Character(1) VARCHAR2(1) NOT NULL Availability Status
1=Open
2=Restricted
3=Hold
4=Rejected

Default Value: 1

24 AVAIL_STATUS_TYPE Character(4) VARCHAR2(4) NOT NULL Status Type

Prompt Table: QUARANTINE_INV

25 QTY_AVAILABLE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Available
26 QTY_AVAILABLE_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity Available
27 QTY_ALLOCATED Signed Number(17,4) DECIMAL(15,4) NOT NULL Allocated quantity
28 QTY_ALLOC_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity allocation
29 NETTABLE_FLG Character(1) VARCHAR2(1) NOT NULL Nettable

Y/N Table Edit

Default Value: Y

30 NON_OWN_FLAG Character(1) VARCHAR2(1) NOT NULL 07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o
N=No
Y=Yes

Y/N Table Edit

Default Value: N

31 WIP_LOC_FLG Character(1) VARCHAR2(1) NOT NULL WIP Location Flag

Y/N Table Edit

Default Value: N

32 PHYS_CYC_INV_FLG Character(1) VARCHAR2(1) NOT NULL In Physical/Cyclic Inventory