DBA Data[Home] [Help]

APPS.WIP_MOVPROC_PRIV dependencies on MTL_ITEM_REVISIONS

Line 6563: mtl_item_revisions mir,

6559: bom_resources br,
6560: bom_calendar_dates bcd1,
6561: bom_calendar_dates bcd2,
6562: fnd_user fu,
6563: mtl_item_revisions mir,
6564: mtl_system_items msi,
6565: mtl_parameters mp,
6566: hr_organization_information hoi,
6567: wip_operation_resources wor,

Line 6635: FROM mtl_item_revisions mir1,

6631: AND mir.inventory_item_id = msi.inventory_item_id
6632: AND mir.organization_id = msi.organization_id
6633: AND mir.revision =
6634: (SELECT MAX(revision)
6635: FROM mtl_item_revisions mir1,
6636: eng_revised_items eri
6637: WHERE mir1.inventory_item_id = mir.inventory_item_id
6638: AND mir1.organization_id = mir.organization_id
6639: AND mir1.effectivity_date <= wmti.transaction_date