DBA Data[Home] [Help]

APPS.ENG_RELATED_ENTITY_PKG dependencies on MTL_ITEM_REVISIONS_B

Line 391: from mtl_item_revisions_b mirb,

387: (select nvl(mirb.lifecycle_id, msi.lifecycle_id) as lifecycle_id,
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