DBA Data[Home] [Help]

APPS.WIP_MOVPROC_PRIV dependencies on MTL_ITEM_REVISIONS

Line 6718: mtl_item_revisions mir,

6714: bom_resources br,
6715: bom_calendar_dates bcd1,
6716: bom_calendar_dates bcd2,
6717: fnd_user fu,
6718: mtl_item_revisions mir,
6719: mtl_system_items msi,
6720: mtl_parameters mp,
6721: hr_organization_information hoi,
6722: wip_operation_resources wor,

Line 6791: FROM mtl_item_revisions mir1,

6787: AND mir.inventory_item_id = msi.inventory_item_id
6788: AND mir.organization_id = msi.organization_id
6789: AND mir.revision =
6790: (SELECT MAX(revision)
6791: FROM mtl_item_revisions mir1,
6792: eng_revised_items eri
6793: WHERE mir1.inventory_item_id = mir.inventory_item_id
6794: AND mir1.organization_id = mir.organization_id
6795: AND mir1.effectivity_date <= wmti.transaction_date