DBA Data[Home] [Help]

APPS.POS_UTIL_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 281: FROM mtl_system_items_b msi,

277: BEGIN
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