APPS.RCV_AVAILABILITY dependencies on PO_LINES_ALL

Line 168: po_lines_all pol,

164: pol.item_id,
165: pol.unit_meas_lookup_code unit_of_measure,
166: si.primary_unit_of_measure
167: FROM po_line_locations_all pll,
168: po_lines_all pol,
169: po_distributions_all pod,
170: mtl_system_items si
171: WHERE pll.line_location_id = p_supply_demand_line_id
172: AND pll.po_line_id = pol.po_line_id

Line 957: po_lines_all pol,

953: */
954: SELECT 'Y'
955: INTO x_valid_status
956: FROM po_line_locations_all pll,
957: po_lines_all pol,
958: po_headers_all poh
959: WHERE pol.po_header_id = poh.po_header_id
960: AND pll.po_line_id = pol.po_line_id
961: AND NVL(pll.approved_flag, 'N') = 'Y'