DBA Data[Home] [Help]

APPS.PO_INVOICES_SV2 dependencies on PO_LINES_ALL

Line 231: po_lines_all pls,

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

Line 326: po_lines_all pls,

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

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

2279: l_tax_classification_code VARCHAR2(30);
2280: x_invoiced_quantity NUMBER :=0; -- Added for bug 6822594
2281: x_invoiced_unit_price NUMBER :=0; -- Added for bug 6822594
2282: X_invoiced_amount NUMBER :=0; -- Added for bug 6822594
2283: x_item_id po_lines_all.item_id%type ; -- Added for bug 6822594
2284: x_po_uom po_lines_all.unit_meas_lookup_code%type; -- Added for bug 6822594
2285: X_conversion_factor NUMBER :=0; -- Added for bug 6822594
2286:
2287: BEGIN

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

2280: x_invoiced_quantity NUMBER :=0; -- Added for bug 6822594
2281: x_invoiced_unit_price NUMBER :=0; -- Added for bug 6822594
2282: X_invoiced_amount NUMBER :=0; -- Added for bug 6822594
2283: x_item_id po_lines_all.item_id%type ; -- Added for bug 6822594
2284: x_po_uom po_lines_all.unit_meas_lookup_code%type; -- Added for bug 6822594
2285: X_conversion_factor NUMBER :=0; -- Added for bug 6822594
2286:
2287: BEGIN
2288: IF (g_asn_debug = 'Y') THEN

Line 2542: FROM po_lines_all

2538:
2539: --Move it out of the following If condition to get item_id for bug 7658186
2540: SELECT item_id,UNIT_MEAS_LOOKUP_CODE
2541: INTO x_item_id , x_po_uom
2542: FROM po_lines_all
2543: WHERE PO_LINE_ID = X_po_line_id;
2544:
2545: -- Bug 9558069 - adding condition to exclude amount basised
2546: IF X_match_option = 'R' AND X_matching_basis <> 'AMOUNT'

Line 2551: FROM po_lines_all

2547: THEN
2548: /*Move it out of If condition to get item_id for bug 7658186
2549: SELECT item_id,UNIT_MEAS_LOOKUP_CODE
2550: INTO x_item_id , x_po_uom
2551: FROM po_lines_all
2552: WHERE PO_LINE_ID = X_po_line_id;*/
2553:
2554: X_invoiced_quantity := X_quantity;
2555: