APPS.GML_AUDIT_REPORTS dependencies on PO_ORDR_DTL

Line 108: FROM po_ordr_dtl

104: l_linecnt NUMBER;
105:
106: CURSOR lcnt_cur IS
107: SELECT count(*)
108: FROM po_ordr_dtl
109: WHERE po_id=p_id;
110:
111: BEGIN
112: OPEN lcnt_cur;

Line 130: FROM po_ordr_dtl

126: l_linecnt NUMBER;
127:
128: CURSOR lcnt_cur IS
129: SELECT count(*)
130: FROM po_ordr_dtl
131: WHERE po_id IN (SELECT po_id
132: FROM cpg_oragems_mapping f
133: WHERE f.po_header_id = p_hid
134: AND nvl(po_release_id,0)>0);

Line 155: FROM po_ordr_dtl

151: l_cost NUMBER;
152:
153: CURSOR cost_cur IS
154: SELECT SUM(order_qty1*net_price)
155: FROM po_ordr_dtl
156: WHERE po_id=p_id
157: AND cancellation_code is NULL;
158:
159: BEGIN

Line 178: FROM po_ordr_dtl

174: l_cost NUMBER;
175:
176: CURSOR cost_cur IS
177: SELECT SUM(order_qty1*net_price)
178: FROM po_ordr_dtl
179: WHERE po_id IN (SELECT po_id
180: FROM cpg_oragems_mapping f
181: WHERE f.po_header_id = p_hid
182: AND nvl(po_release_id,0)>0);

Line 236: po_ordr_dtl b

232:
233: CURSOR gms_itm_cur IS
234: SELECT a.item_no
235: FROM ic_item_mst a,
236: po_ordr_dtl b
237: WHERE a.item_id=b.item_id
238: AND b.line_id=p_glid;
239:
240: CURSOR ofi_itm_cur IS

Line 277: FROM po_ordr_dtl

273: l_ofi_stat VARCHAR2(20);
274:
275: CURSOR gms_sts_cur IS
276: SELECT DECODE(po_status,0,'OPEN',1,'CANCEL',20,'CLOSE','X')
277: FROM po_ordr_dtl
278: WHERE line_id=p_glid;
279:
280: CURSOR ofi_sts_cur IS
281: SELECT DECODE(closed_code,'OPEN','OPEN','CLOSED','CLOSE',