DBA Data[Home] [Help]

APPS.BOM_RTG_ISETUP_IMP dependencies on MTL_RTG_ITEM_REVISIONS

Line 210: FROM mtl_rtg_item_revisions rev

206: AND item.concatenated_segments = tmp.AssemblyItemName
207: AND tmp.AssemblyItemName = P_assembly_item_name
208: AND tmp.OrganizationCode = P_organization_code
209: AND NOT EXISTS (SELECT 1
210: FROM mtl_rtg_item_revisions rev
211: WHERE rev.organization_id = item.organization_id
212: AND rev.inventory_item_id = item.inventory_item_id
213: AND rev.process_revision = tmp.revision)
214: UNION ALL

Line 249: FROM mtl_rtg_item_revisions rev

245: AND item.concatenated_segments = tmp.AssemblyItemName
246: AND tmp.AssemblyItemName = P_assembly_item_name
247: AND tmp.OrganizationCode = P_organization_code
248: AND EXISTS (SELECT 1
249: FROM mtl_rtg_item_revisions rev
250: WHERE rev.organization_id = item.organization_id
251: AND rev.inventory_item_id = item.inventory_item_id
252: AND rev.process_revision = tmp.revision);
253: