[Home] [Help]
View: PMI_LOT_SHARED_V
Product: | PMI - Process Manufacturing Intelligence (Obsolete) |
Description: | This view lists lots that share ingredient lots with another product start lot |
Implementation/DBA Data: |
APPS.PMI_LOT_SHARED_V
|
View Text
SELECT LEAF_V.PRODUCT_ITEM_ID START_ITEM_ID
, LEAF_V.PRODUCT_LOT_ID START_LOT_ID
, DEST_V.PRODUCT_ITEM_ID SHARED_ITEM_ID
, DEST_V.PRODUCT_LOT_ID SHARED_LOT_ID
FROM PMI_LOT_SOURCE_LEAF_V LEAF_V
, PMI_LOT_GENEALOGY DEST_V
WHERE DEST_V.INGRED_LOT_ID = LEAF_V.INGRED_LOT_ID GROUP BY LEAF_V.PRODUCT_ITEM_ID
, LEAF_V.PRODUCT_LOT_ID
, DEST_V.PRODUCT_ITEM_ID
, DEST_V.PRODUCT_LOT_ID WITH READ ONLY
Columns
Name |
START_ITEM_ID |
START_LOT_ID |
SHARED_ITEM_ID |
SHARED_LOT_ID |