APPS.PO_INQ_SV dependencies on PO_LINE_LOCATIONS_ALL

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

311: x_min_unit NUMBER;
312: x_precision NUMBER;
313: x_dist_amount NUMBER;
314:
315: l_value_basis PO_LINE_LOCATIONS_ALL.value_basis%TYPE; --
316: l_qty_cancelled NUMBER := 0;
317: l_amt_cancelled NUMBER := 0;
318:
319: BEGIN

Line 329: FROM po_line_locations_all poll

325: --
326:
327: SELECT poll.value_basis
328: INTO l_value_basis
329: FROM po_line_locations_all poll
330: WHERE poll.line_location_id = p_po_line_loc_id;
331:
332: --
333:

Line 663: FROM po_headers_all POH, po_line_locations_all PLL --

659: */
660:
661: SELECT POH.CLM_DOCUMENT_NUMBER
662: INTO x_po_number
663: FROM po_headers_all POH, po_line_locations_all PLL --
664: WHERE POH.po_header_id = PLL.po_header_id and
665: PLL.line_location_id = x_line_location_id;
666:
667:

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

1393:
1394: cursor c1 is
1395: select ship_to_organization_id ,
1396: ship_to_location_id
1397: from po_line_locations_all --< Shared Proc FPJ >
1398: where line_location_id = x_po_line_location_id;
1399:
1400: cursor c2 is
1401: select terms_id

Line 1474: po_line_locations_all pll

1470: SELECT gsb.chart_of_accounts_id
1471: INTO x_purchasing_ou_coa_id
1472: FROM gl_sets_of_books gsb,
1473: financials_system_params_all fspa,
1474: po_line_locations_all pll
1475: WHERE pll.line_location_id = x_po_line_location_id
1476: AND fspa.org_id = pll.org_id
1477: AND gsb.set_of_books_id = fspa.set_of_books_id;
1478: EXCEPTION