APPS.POA_EDW_SUPPERF dependencies on PO_LINE_LOCATIONS_ALL

Line 232: FROM po_line_locations_all

228: --
229: BEGIN
230: SELECT last_update_date
231: INTO v_line_loc_date
232: FROM po_line_locations_all
233: WHERE line_location_id = p_line_location_id;
234: END;
235:
236: RETURN(GREATEST(NVL(v_max_rcv_trx_date, v_line_loc_date),

Line 520: FROM po_line_locations_all pll

516: IF sysdate > (p_expected_date + p_days_late_allowed) THEN
517:
518: SELECT pll.quantity - pll.quantity_cancelled - pll.quantity_received
519: INTO v_qty_pastdue
520: FROM po_line_locations_all pll
521: WHERE pll.line_location_id = p_line_location_id
522: AND pll.quantity - pll.quantity_cancelled - pll.quantity_received >= 0;
523:
524: ELSE

Line 745: po_line_locations_all pll

741: v_item_id, v_unit_meas_lookup_code, v_currency_code,
742: v_approved_date, v_quantity, v_need_by_date, v_creation_date
743: FROM po_headers_all poh,
744: po_lines_all pol,
745: po_line_locations_all pll
746: WHERE pll.line_location_id = p_line_location_id
747: AND pll.po_line_id = pol.po_line_id
748: AND pol.po_header_id = poh.po_header_id;
749:

Line 779: po_line_locations_all pll

775: FROM gl_sets_of_books gsob,
776: financials_system_params_all fsp,
777: po_headers_all poh,
778: po_lines_all pol,
779: po_line_locations_all pll
780: WHERE pol.item_id = v_item_id
781: AND pol.unit_meas_lookup_code = v_unit_meas_lookup_code
782: AND ((Nvl(pll.shipment_type,'PRICE BREAK') = 'PRICE BREAK'
783: AND v_approved_date BETWEEN NVL(poh.start_date, Nvl(pll.approved_date,poh.approved_date)) AND NVL(poh.end_date, v_approved_date)

Line 813: FROM po_line_locations_all pll

809: x_progress := '005';
810:
811: SELECT pll.price_override
812: INTO v_best_price
813: FROM po_line_locations_all pll
814: WHERE line_location_id = p_line_location_id;
815:
816: END IF;
817: