DBA Data[Home] [Help]

APPS.GML_AUDIT_REPORTS dependencies on PO_LINES_ALL

Line 63: FROM po_lines_all

59: l_cost NUMBER;
60:
61: CURSOR cost_cur IS
62: SELECT SUM(quantity*unit_price)
63: FROM po_lines_all
64: WHERE po_header_id=p_hid;
65:
66: BEGIN
67: OPEN cost_cur;

Line 242: FROM po_lines_all a,

238: AND b.line_id=p_glid;
239:
240: CURSOR ofi_itm_cur IS
241: SELECT segment1
242: FROM po_lines_all a,
243: mtl_system_items b
244: WHERE a.item_id=b.inventory_item_id
245: AND a.po_line_id=p_olid;
246: BEGIN