IN_ALLOC_WBLLVW

(SQL View)
 Index Back

SELECT BUSINESS_UNIT , %DateIn('1900-01-01') , INV_LOT_ID , ' ' , INV_ITEM_ID , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , SUM(QTY) , SUM(QTY_RESERVED) , SUM(QTY_BASE) , SUM(QTY_RESERVED_BASE) , AVAIL_STATUS , AVAIL_STATUS_TYPE , SUM(QTY_AVAILABLE_BASE) , SUM(QTY_AVAILABLE_BASE) , 0 , 0 , NETTABLE_FLG , NON_OWN_FLAG , WIP_LOC_FLG , PHYS_CYC_INV_FLG FROM PS_IN_ALLOC_WB_LVW GROUP BY BUSINESS_UNIT , INV_LOT_ID , INV_ITEM_ID , AVAIL_STATUS , AVAIL_STATUS_TYPE , NETTABLE_FLG , NON_OWN_FLAG , WIP_LOC_FLG , PHYS_CYC_INV_FLG

# 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 STAGED_DATE Date(10) DATE Staged Date

Default Value: %DATE

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

Default Value: INSTALLATION_IN.DFLT_INV_LOT_ID

Prompt Table: %EDIT_LOT_ID

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

Default Value: INSTALLATION_IN.DFLT_SERIAL_ID

5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: BU_ITM_INV_VW

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

Prompt Table: STOR_AREA_VW2

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

Prompt Table: STOR_LEV1_VW2

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

Prompt Table: STOR_LEV2_VW2

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

Prompt Table: STOR_LEV3_VW2

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

Prompt Table: STOR_LEV4_VW2

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

Prompt Table: CNTR_ID_INV

12 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

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

Default Value: 1

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

Prompt Table: QUARANTINE_INV

19 QTY_AVAILABLE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Available
20 QTY_AVAILABLE_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity Available
21 QTY_ALLOCATED Signed Number(17,4) DECIMAL(15,4) NOT NULL Allocated quantity
22 QTY_ALLOC_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity allocation
23 NETTABLE_FLG Character(1) VARCHAR2(1) NOT NULL Nettable

Y/N Table Edit

Default Value: Y

24 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

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

Y/N Table Edit

Default Value: N

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