MG_LOTCONSCH_VW

(SQL View)
Index Back

Consigned lot controlled view

mmt 6/00 - created for use as a prompt table for lot controlled consigned items.

SELECT DISTINCT a.business_unit , c.prdn_area_code , a.inv_item_id , a.inv_lot_id FROM ps_physical_inv a , ps_sf_prdnid_headr b , PS_SF_PRDN_AREA c WHERE a.business_unit = b.business_unit AND b.business_unit = c.business_unit AND a.business_unit = c.business_unit AND a.avail_status IN ('1','2') AND b.prdn_area_code = c.prdn_area_code 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) OR (a.storage_area = c.non_own_stor_area AND a.stor_level_1 = c.non_own_stor_lev1 AND a.stor_level_2 = c.non_own_stor_lev2 AND a.stor_level_3 = c.non_own_stor_lev3 AND a.stor_level_4 = c.non_own_stor_lev4))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
3 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.
4 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID