DBA Data[Home] [Help]

APPS.WMS_EPC_PVT dependencies on MTL_ITEM_REVISIONS_B

Line 430: FROM mtl_cross_references MCR, mtl_item_revisions_b mirb --USING base TABLE FOR PERFORMANCE

426:
427: BEGIN
428: SELECT 1, To_number(mcr.cross_reference),mirb.revision_id INTO
429: l_found_gtin,l_gtin,l_rev_id
430: FROM mtl_cross_references MCR, mtl_item_revisions_b mirb --USING base TABLE FOR PERFORMANCE
431: WHERE mcr.cross_reference_type = G_PROFILE_GTIN
432: AND mcr.inventory_item_id = p_item_id
433: AND mcr.uom_code = l_mtl_uom.UOM_CODE
434: AND mcr.inventory_item_id = mirb.inventory_item_id