APPS.PO_INVOICES_SV2 dependencies on PO_LINE_LOCATIONS_ALL

Line 35: po_line_locations_all

31:
32: SELECT
33: ship_to_location_id INTO l_ship_to_location_id
34: FROM
35: po_line_locations_all
36: WHERE
37: line_location_id = p_po_line_location_id;
38: IF (g_asn_debug = 'Y') THEN
39: asn_debug.put_line('po_line_location_id = ' || p_po_line_location_id || ' has ship to location id = ' || l_ship_to_location_id);

Line 222: po_line_locations_all plls,

218: --Bugfix 5407632 - Using _all tables instead of views.
219: po_headers_all phs,
220: -- po_releases_all prs, /*Bug 5443196*/
221: po_lines_all pls,
222: po_line_locations_all plls,
223: rcv_shipment_headers rsh,
224: rcv_shipment_lines rsl,
225: rcv_transactions rts
226: WHERE rts.shipment_header_id = rsh.shipment_header_id

Line 300: po_line_locations_all plls,

296: --Bugfix 5407632 - Using _all tables instead of views.
297: po_headers_all phs,
298: po_releases_all prs,
299: po_lines_all pls,
300: po_line_locations_all plls,
301: rcv_shipment_headers rsh,
302: rcv_shipment_lines rsl,
303: rcv_transactions rts
304: WHERE rts.shipment_header_id = rsh.shipment_header_id

Line 531: x_curr_shipment_type po_line_locations_all.shipment_type%type;

527: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
528: /* */
529:
530: /* R12 Complex Work.*/
531: x_curr_shipment_type po_line_locations_all.shipment_type%type;
532:
533: /*Bug: 5125624*/
534: l_ship_to_location_id PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE;
535: l_tax_classification_code VARCHAR2(30);