DBA Data[Home] [Help]

APPS.PO_LINES_SV11 dependencies on PO_LINES_ALL

Line 182: l_orig_amount po_lines_all.amount%TYPE; -- Bug 3262883

178: X_ship_org_id NUMBER := NULL;
179: X_secondary_quantity_ship NUMBER := NULL;
180: X_secondary_quantity_ship_new NUMBER := NULL;
181:
182: l_orig_amount po_lines_all.amount%TYPE; -- Bug 3262883
183: l_line_type po_lines_all.order_type_lookup_code%TYPE; -- Bug 3262883
184: l_purchase_basis po_lines_all.purchase_basis%TYPE; -- Bug 3262883
185: l_ip_category_id PO_LINES_ALL.ip_category_id%TYPE; -- Bug 7577670
186:

Line 183: l_line_type po_lines_all.order_type_lookup_code%TYPE; -- Bug 3262883

179: X_secondary_quantity_ship NUMBER := NULL;
180: X_secondary_quantity_ship_new NUMBER := NULL;
181:
182: l_orig_amount po_lines_all.amount%TYPE; -- Bug 3262883
183: l_line_type po_lines_all.order_type_lookup_code%TYPE; -- Bug 3262883
184: l_purchase_basis po_lines_all.purchase_basis%TYPE; -- Bug 3262883
185: l_ip_category_id PO_LINES_ALL.ip_category_id%TYPE; -- Bug 7577670
186:
187:

Line 184: l_purchase_basis po_lines_all.purchase_basis%TYPE; -- Bug 3262883

180: X_secondary_quantity_ship_new NUMBER := NULL;
181:
182: l_orig_amount po_lines_all.amount%TYPE; -- Bug 3262883
183: l_line_type po_lines_all.order_type_lookup_code%TYPE; -- Bug 3262883
184: l_purchase_basis po_lines_all.purchase_basis%TYPE; -- Bug 3262883
185: l_ip_category_id PO_LINES_ALL.ip_category_id%TYPE; -- Bug 7577670
186:
187:
188: --OPM bug3455686

Line 185: l_ip_category_id PO_LINES_ALL.ip_category_id%TYPE; -- Bug 7577670

181:
182: l_orig_amount po_lines_all.amount%TYPE; -- Bug 3262883
183: l_line_type po_lines_all.order_type_lookup_code%TYPE; -- Bug 3262883
184: l_purchase_basis po_lines_all.purchase_basis%TYPE; -- Bug 3262883
185: l_ip_category_id PO_LINES_ALL.ip_category_id%TYPE; -- Bug 7577670
186:
187:
188: --OPM bug3455686
189: CURSOR opm_fetch_quantity IS

Line 388: from po_lines_all

384: */
385: -- Bug 3262883
386: select order_type_lookup_code,purchase_basis,amount
387: into l_line_type,l_purchase_basis ,l_orig_amount
388: from po_lines_all
389: where po_line_id = X_po_line_id;
390:
391: if ((X_orig_quantity <> X_quantity ) or (l_orig_amount <> X_amount_db))
392: then