DBA Data[Home] [Help]

APPS.ENG_ATTACHMENT_IMPLEMENTATION dependencies on MTL_SYSTEM_ITEMS

Line 2460: MTL_SYSTEM_ITEMS msi

2456: nvl(mirb.current_phase_id , msi.current_phase_id) as phase_id,
2457: msi.item_catalog_group_id item_catalog_group_id,
2458: msi.inventory_item_id, msi.organization_id , mirb.revision_id
2459: from mtl_item_revisions_b mirb,
2460: MTL_SYSTEM_ITEMS msi
2461: where mirb.INVENTORY_ITEM_ID(+) = msi.INVENTORY_ITEM_ID
2462: and mirb.ORGANIZATION_ID(+)= msi.ORGANIZATION_ID
2463: and mirb.revision_id(+) = c2.pk3_value
2464: and msi.INVENTORY_ITEM_ID = c2.pk2_value