APPS.PO_ITEMS_SV dependencies on PO_LINE_LOCATIONS_ALL

Line 730: FROM po_line_locations_all PLL,

726: )
727: SELECT l_key,
728: MIR.revision,
729: count(*)
730: FROM po_line_locations_all PLL,
731: mtl_item_revisions MIR,
732: org_organization_definitions OOD
733: WHERE PLL.po_line_id = p_po_line_id
734: AND NVL(PLL.cancel_flag, 'N') = 'N'

Line 744: FROM po_line_locations_all

740: GROUP BY MIR.revision;
741:
742: SELECT count(*)
743: INTO l_shipment_count
744: FROM po_line_locations_all
745: WHERE po_line_id = p_po_line_id
746: AND NVL(cancel_flag, 'N') = 'N';
747:
748: BEGIN