DBA Data[Home] [Help]

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 232: po_line_locations_all plls,

228: --Bugfix 5407632 - Using _all tables instead of views.
229: po_headers_all phs,
230: -- po_releases_all prs, /*Bug 5443196*/
231: po_lines_all pls,
232: po_line_locations_all plls,
233: rcv_shipment_headers rsh,
234: rcv_shipment_lines rsl,
235: inl_ship_lines_all isl, -- PoR with LCM project
236: rcv_transactions rts

Line 327: po_line_locations_all plls,

323: --Bugfix 5407632 - Using _all tables instead of views.
324: po_headers_all phs,
325: po_releases_all prs,
326: po_lines_all pls,
327: po_line_locations_all plls,
328: rcv_shipment_headers rsh,
329: rcv_shipment_lines rsl,
330: inl_ship_lines_all isl, -- PoR with LCM project
331: rcv_transactions rts

Line 582: x_curr_shipment_type po_line_locations_all.shipment_type%type;

578: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
579: /* */
580:
581: /* R12 Complex Work.*/
582: x_curr_shipment_type po_line_locations_all.shipment_type%type;
583:
584: /*Bug: 5125624*/
585: l_ship_to_location_id PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE;
586: l_tax_classification_code VARCHAR2(30);