DBA Data[Home] [Help]

APPS.BOMPBXIN dependencies on MTL_ITEM_REVISIONS_B

Line 960: FROM MTL_ITEM_REVISIONS_B MIR

956: If show_rev = 1 then
957: update BOM_SMALL_EXPL_TEMP BSET
958: set CURRENT_REVISION =
959: (select MAX(MIR.revision)
960: FROM MTL_ITEM_REVISIONS_B MIR
961: where INVENTORY_ITEM_ID = BSET.COMPONENT_ITEM_ID
962: AND ORGANIZATION_ID = BSET.ORGANIZATION_ID
963: AND MIR.EFFECTIVITY_DATE <= rev_date
964: AND (impl_flag <> 1 OR (impl_flag = 1 AND IMPLEMENTATION_DATE IS NOT NULL))