APPS.RCV_AVAILABILITY dependencies on PO_LINES_ALL

Line 193: po_lines_all pol,

189: pol.item_id,
190: pol.unit_meas_lookup_code unit_of_measure,
191: null primary_unit_of_measure
192: FROM po_line_locations_all pll,
193: po_lines_all pol,
194: po_distributions_all pod
195: WHERE pll.line_location_id = p_supply_demand_line_id
196: AND pll.po_line_id = pol.po_line_id
197: AND pol.item_id IS NULL

Line 212: po_lines_all pol,

208: pol.item_id,
209: pol.unit_meas_lookup_code unit_of_measure,
210: si.primary_unit_of_measure primary_unit_of_measure
211: FROM po_line_locations_all pll,
212: po_lines_all pol,
213: po_distributions_all pod,
214: mtl_system_items si
215: WHERE pll.line_location_id = p_supply_demand_line_id
216: AND pll.po_line_id = pol.po_line_id

Line 1070: po_lines_all pol,

1066: */
1067: SELECT 'Y'
1068: INTO x_valid_status
1069: FROM po_line_locations_all pll,
1070: po_lines_all pol,
1071: po_headers_all poh
1072: WHERE pol.po_header_id = poh.po_header_id
1073: AND pll.po_line_id = pol.po_line_id
1074: AND NVL(pll.approved_flag, 'N') = 'Y'