DBA Data[Home] [Help]

APPS.PO_PRICE_BREAK_GRP dependencies on PO_LINE_LOCATIONS_ALL

Line 190: l_ship_to_org_id po_line_locations_all.ship_to_organization_id%TYPE; /* */

186: v_ga_currency po_headers_all.currency_code%TYPE; -- FPI GA
187: v_conversion_rate po_headers_all.rate%TYPE; -- FPI GA
188: v_po_rate po_headers_all.rate%TYPE; -- FPI GA
189:
190: l_ship_to_org_id po_line_locations_all.ship_to_organization_id%TYPE; /* */
191:
192: l_dummy_var BOOLEAN; -- <2694908>
193:
194: l_progress varchar2(4);

Line 251: , po_line_locations_all poll -- FPI GA

247: poll.unit_meas_lookup_code)
248: , poll.line_location_id -- SERVICES FPJ
249: FROM po_headers_all poh -- FPI GA
250: , po_lines_all pol -- FPI GA
251: , po_line_locations_all poll -- FPI GA
252: WHERE poh.po_header_id = p_source_document_header_id
253: and poh.po_header_id = pol.po_header_id
254: and pol.line_num = p_source_document_line_num
255: and pol.po_line_id = poll.po_line_id -- bug4043100

Line 910: l_price_break_id po_line_locations_all.line_location_id%TYPE; --

906: l_rate_type_out po_requisition_lines.rate_type%TYPE;
907: l_rate_date_out po_requisition_lines.rate_date%TYPE;
908: l_rate_out po_requisition_lines.rate%TYPE;
909: l_uom po_requisitions_interface.unit_of_measure%TYPE;
910: l_price_break_id po_line_locations_all.line_location_id%TYPE; --
911: l_progress VARCHAR2(3) := NULL;
912:
913: --
914: l_org_id po_requisitions_interface.org_id%TYPE;