APPS.GML_AUDIT_REPORTS dependencies on PO_LINE_LOCATIONS_ALL

Line 11: FROM po_line_locations_all

7: l_linecnt NUMBER;
8:
9: CURSOR lcnt_cur IS
10: SELECT count(*)
11: FROM po_line_locations_all
12: WHERE po_header_id = p_hid;
13:
14: BEGIN
15: OPEN lcnt_cur;

Line 36: FROM po_line_locations_all

32: l_linecnt NUMBER;
33:
34: CURSOR lcnt_cur IS
35: SELECT count(*)
36: FROM po_line_locations_all
37: WHERE po_header_id = p_hid
38: AND nvl(po_release_id, 0) > 0;
39:
40: BEGIN

Line 85: FROM po_line_locations_all

81: l_cost NUMBER;
82:
83: CURSOR cost_cur IS
84: SELECT SUM(quantity*price_override)
85: FROM po_line_locations_all
86: WHERE po_header_id=p_hid
87: AND nvl(po_release_id,0) > 0;
88:
89: BEGIN

Line 283: FROM po_line_locations_all

279:
280: CURSOR ofi_sts_cur IS
281: SELECT DECODE(closed_code,'OPEN','OPEN','CLOSED','CLOSE',
282: 'FINALLY CLOSED','CLOSE','CLOSED FOR RECEIVING','CLOSE','OPEN')
283: FROM po_line_locations_all
284: WHERE line_location_id=p_ollid;
285:
286: BEGIN
287: OPEN gms_sts_cur;