APPS.GML_PO_RECV1_PKG dependencies on PO_RECV_DTL

Line 153: v_received_qty po_recv_dtl.recv_qty1%TYPE;

149: v_line_no po_ordr_dtl.line_no%TYPE;
150: v_org_id gl_plcy_mst.org_id%TYPE;
151: v_orgn_code po_ordr_hdr.orgn_code%TYPE;
152: v_returned_qty po_rtrn_dtl.return_qty1%TYPE;
153: v_received_qty po_recv_dtl.recv_qty1%TYPE;
154: v_status po_ordr_dtl.po_status%TYPE;
155: v_actual_received_qty NUMBER;
156: v_created_by po_recv_dtl.created_by%TYPE;
157: v_last_updated_by po_recv_dtl.last_updated_by%TYPE;

Line 156: v_created_by po_recv_dtl.created_by%TYPE;

152: v_returned_qty po_rtrn_dtl.return_qty1%TYPE;
153: v_received_qty po_recv_dtl.recv_qty1%TYPE;
154: v_status po_ordr_dtl.po_status%TYPE;
155: v_actual_received_qty NUMBER;
156: v_created_by po_recv_dtl.created_by%TYPE;
157: v_last_updated_by po_recv_dtl.last_updated_by%TYPE;
158: v_last_update_login po_recv_dtl.last_update_login%TYPE;
159:
160: v_order_um1 VARCHAR2(4);

Line 157: v_last_updated_by po_recv_dtl.last_updated_by%TYPE;

153: v_received_qty po_recv_dtl.recv_qty1%TYPE;
154: v_status po_ordr_dtl.po_status%TYPE;
155: v_actual_received_qty NUMBER;
156: v_created_by po_recv_dtl.created_by%TYPE;
157: v_last_updated_by po_recv_dtl.last_updated_by%TYPE;
158: v_last_update_login po_recv_dtl.last_update_login%TYPE;
159:
160: v_order_um1 VARCHAR2(4);
161:

Line 158: v_last_update_login po_recv_dtl.last_update_login%TYPE;

154: v_status po_ordr_dtl.po_status%TYPE;
155: v_actual_received_qty NUMBER;
156: v_created_by po_recv_dtl.created_by%TYPE;
157: v_last_updated_by po_recv_dtl.last_updated_by%TYPE;
158: v_last_update_login po_recv_dtl.last_update_login%TYPE;
159:
160: v_order_um1 VARCHAR2(4);
161:
162: x_total_recv_qty NUMBER := 0 ;

Line 204: FROM po_recv_dtl

200:
201: /* Added these 2 cursors for Bug# 1094230 */
202: CURSOR recv_qty_cur IS
203: SELECT NVL(sum(recv_qty1), 0),recv_um1
204: FROM po_recv_dtl
205: WHERE po_id = G_po_id
206: AND poline_id = G_poline_id
207: AND recv_status <> -1
208: GROUP BY recv_um1;

Line 330: FROM po_recv_dtl

326:
327:
328: SELECT NVL(sum(recv_qty1), 0)
329: INTO v_received_qty
330: FROM po_recv_dtl
331: WHERE po_id = G_po_id
332: AND poline_id = G_poline_id
333: AND recv_status <> -1;
334: */

Line 340: FROM po_recv_dtl

336:
337:
338: SELECT created_by, last_updated_by, last_update_login
339: INTO v_created_by, v_last_updated_by, v_last_update_login
340: FROM po_recv_dtl
341: WHERE po_id = G_po_id
342: AND poline_id = G_poline_id
343: /* AND recv_status <> -1 */
344: AND last_update_date = (select max(last_update_date) from po_recv_dtl

Line 344: AND last_update_date = (select max(last_update_date) from po_recv_dtl

340: FROM po_recv_dtl
341: WHERE po_id = G_po_id
342: AND poline_id = G_poline_id
343: /* AND recv_status <> -1 */
344: AND last_update_date = (select max(last_update_date) from po_recv_dtl
345: WHERE po_id = G_po_id
346: AND poline_id = G_poline_id);
347: /* AND recv_status <> -1); */
348: