DBA Data[Home] [Help]

APPS.POA_EDW_SUPPERF dependencies on PO_LINES_ALL

Line 744: po_lines_all pol,

740: pll.approved_date, pll.quantity, pll.need_by_date, pll.creation_date INTO
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;

Line 778: po_lines_all pol,

774: lowest_price
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'