DBA Data[Home] [Help]

APPS.ENG_ATTACHMENT_IMPLEMENTATION dependencies on MTL_SYSTEM_ITEMS

Line 2253: MTL_SYSTEM_ITEMS msi

2249: nvl(mirb.current_phase_id , msi.current_phase_id) as phase_id,
2250: msi.item_catalog_group_id item_catalog_group_id,
2251: msi.inventory_item_id, msi.organization_id , mirb.revision_id
2252: from mtl_item_revisions_b mirb,
2253: MTL_SYSTEM_ITEMS msi
2254: where mirb.INVENTORY_ITEM_ID(+) = msi.INVENTORY_ITEM_ID
2255: and mirb.ORGANIZATION_ID(+)= msi.ORGANIZATION_ID
2256: and mirb.revision_id(+) = c2.pk3_value
2257: and msi.INVENTORY_ITEM_ID = c2.pk2_value