APPS.PO_INQ_SV dependencies on PO_LINE_LOCATIONS_ALL

Line 276: l_value_basis PO_LINE_LOCATIONS_ALL.value_basis%TYPE; --

272: x_min_unit NUMBER;
273: x_precision NUMBER;
274: x_dist_amount NUMBER;
275:
276: l_value_basis PO_LINE_LOCATIONS_ALL.value_basis%TYPE; --
277:
278: BEGIN
279:
280: --

Line 288: FROM po_line_locations_all poll

284: --
285:
286: SELECT poll.value_basis
287: INTO l_value_basis
288: FROM po_line_locations_all poll
289: WHERE poll.line_location_id = p_po_line_loc_id;
290:
291: --
292:

Line 611: FROM po_headers_all POH, po_line_locations_all PLL --

607: */
608:
609: SELECT POH.segment1
610: INTO x_po_number
611: FROM po_headers_all POH, po_line_locations_all PLL --
612: WHERE POH.po_header_id = PLL.po_header_id and
613: PLL.line_location_id = x_line_location_id;
614:
615:

Line 1343: from po_line_locations_all --< Shared Proc FPJ >

1339:
1340: cursor c1 is
1341: select ship_to_organization_id ,
1342: ship_to_location_id
1343: from po_line_locations_all --< Shared Proc FPJ >
1344: where line_location_id = x_po_line_location_id;
1345:
1346: cursor c2 is
1347: select terms_id

Line 1420: po_line_locations_all pll

1416: SELECT gsb.chart_of_accounts_id
1417: INTO x_purchasing_ou_coa_id
1418: FROM gl_sets_of_books gsb,
1419: financials_system_params_all fspa,
1420: po_line_locations_all pll
1421: WHERE pll.line_location_id = x_po_line_location_id
1422: AND fspa.org_id = pll.org_id
1423: AND gsb.set_of_books_id = fspa.set_of_books_id;
1424: EXCEPTION