SF_SUB_LOT_VW

(SQL View)
Index Back

Physical Lot View/Sub Item


SELECT DISTINCT BUSINESS_UNIT , INV_ITEM_ID , STORAGE_AREA , STOR_LEVEL_1 , STOR_LEVEL_2 , STOR_LEVEL_3 , STOR_LEVEL_4 , CONTAINER_ID , INV_LOT_ID FROM PS_PHYSICAL_INV WHERE (avail_status = '1' OR 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 SUB_ITM_ID Character(18) VARCHAR2(18) NOT NULL 11/30/99 RML Added label "Substitute"
3 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
4 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
5 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
6 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
7 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
8 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID
9 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID