DBA Data[Home] [Help]

APPS.PO_INVOICES_SV2 dependencies on PO_LINES_ALL

Line 221: po_lines_all pls,

217: po_vendors pvds,
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

Line 299: po_lines_all pls,

295: po_vendors pvds,
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

Line 2218: x_item_id po_lines_all.item_id%type ; -- Added for bug 6822594

2214: l_tax_classification_code VARCHAR2(30);
2215: x_invoiced_quantity NUMBER :=0; -- Added for bug 6822594
2216: x_invoiced_unit_price NUMBER :=0; -- Added for bug 6822594
2217: X_invoiced_amount NUMBER :=0; -- Added for bug 6822594
2218: x_item_id po_lines_all.item_id%type ; -- Added for bug 6822594
2219: x_po_uom po_lines_all.unit_meas_lookup_code%type; -- Added for bug 6822594
2220: X_conversion_factor NUMBER :=0; -- Added for bug 6822594
2221:
2222: BEGIN

Line 2219: x_po_uom po_lines_all.unit_meas_lookup_code%type; -- Added for bug 6822594

2215: x_invoiced_quantity NUMBER :=0; -- Added for bug 6822594
2216: x_invoiced_unit_price NUMBER :=0; -- Added for bug 6822594
2217: X_invoiced_amount NUMBER :=0; -- Added for bug 6822594
2218: x_item_id po_lines_all.item_id%type ; -- Added for bug 6822594
2219: x_po_uom po_lines_all.unit_meas_lookup_code%type; -- Added for bug 6822594
2220: X_conversion_factor NUMBER :=0; -- Added for bug 6822594
2221:
2222: BEGIN
2223: IF (g_asn_debug = 'Y') THEN

Line 2420: FROM po_lines_all

2416: THEN
2417:
2418: SELECT item_id,UNIT_MEAS_LOOKUP_CODE
2419: INTO x_item_id , x_po_uom
2420: FROM po_lines_all
2421: WHERE PO_LINE_ID = X_po_line_id;
2422:
2423: X_invoiced_quantity := X_quantity;
2424: -- Quantity in Receipt uom