DBA Data[Home] [Help]

APPS.POS_UTIL_PKG dependencies on MTL_ITEM_REVISIONS

Line 282: mtl_item_revisions rev

278: SELECT max(rev.revision),
279: max(msi.revision_qty_control_code)
280: INTO var_revision, var_revision_ctrl
281: FROM mtl_system_items_b msi,
282: mtl_item_revisions rev
283: WHERE msi.inventory_item_id = p_inventoryItemId
284: AND msi.organization_id = p_organizationId
285: AND rev.inventory_item_id = msi.inventory_item_id
286: AND rev.organization_id = msi.organization_id

Line 289: FROM mtl_item_revisions rev2

285: AND rev.inventory_item_id = msi.inventory_item_id
286: AND rev.organization_id = msi.organization_id
287: AND TRUNC(rev.effectivity_date) =
288: (SELECT TRUNC(max(rev2.effectivity_date))
289: FROM mtl_item_revisions rev2
290: WHERE rev2.implementation_date IS NOT NULL
291: AND rev2.effectivity_date <= TRUNC(SYSDATE)+.99999
292: AND rev2.organization_id = rev.organization_id
293: AND rev2.inventory_item_id = rev.inventory_item_id);