DBA Data[Home] [Help]

APPS.ENG_RELATED_ENTITY_PKG dependencies on MTL_SYSTEM_ITEMS

Line 392: MTL_SYSTEM_ITEMS msi

388: nvl(mirb.current_phase_id , msi.current_phase_id) as phase_id,
389: msi.item_catalog_group_id item_catalog_group_id,
390: msi.inventory_item_id, msi.organization_id , mirb.revision_id
391: from mtl_item_revisions_b mirb,
392: MTL_SYSTEM_ITEMS msi
393: where mirb.INVENTORY_ITEM_ID(+) = msi.INVENTORY_ITEM_ID
394: and mirb.ORGANIZATION_ID(+)= msi.ORGANIZATION_ID
395: and mirb.revision_id(+) = c2.pk3_value
396: and msi.INVENTORY_ITEM_ID = c2.pk2_value