LOT_PRT_INV_VW0

(SQL View)
Index Back

Lot ID Pmt w/CfgCde - Expr Iss


select distinct A.BUSINESS_UNIT, A.INV_ITEM_ID, B.CONFIG_CODE, B.INV_LOT_ID, B.DESCR, B.AVAIL_DATE, B.EXPIRATION_DATE, SUM(A.QTY_BASE - A.QTY_RESERVED_BASE) from PS_PHYSICAL_INV A, PS_LOT_CONTROL_INV B where A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.INV_LOT_ID = B.INV_LOT_ID group by A.BUSINESS_UNIT, A.INV_ITEM_ID, B.CONFIG_CODE, B.INV_LOT_ID, B.DESCR, B.AVAIL_DATE, B.EXPIRATION_DATE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
4 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 AVAIL_DATE Date(10) DATE Availability Date
7 EXPIRATION_DATE Date(10) DATE Expiration Date
8 QTY_AVAILABLE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Available