APPS.GML_PO_RECV1_PKG dependencies on PO_ORDR_DTL

Line 55: FROM po_ordr_dtl

51: WHERE po_id = G_po_id;
52:
53: CURSOR line_no_cur IS
54: SELECT line_no
55: FROM po_ordr_dtl
56: WHERE line_id = G_poline_id;
57: BEGIN
58: OPEN po_no_cur;
59: FETCH po_no_cur INTO v_po_no;

Line 149: v_line_no po_ordr_dtl.line_no%TYPE;

145:
146:
147: PROCEDURE sum_recv AS
148: v_po_no po_ordr_hdr.po_no%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;

Line 154: v_status po_ordr_dtl.po_status%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;
158: v_last_update_login po_recv_dtl.last_update_login%TYPE;

Line 185: FROM po_ordr_dtl

181: WHERE po_id = vc_po_id;
182:
183: CURSOR line_no_cur(vc_po_id NUMBER, vc_line_id NUMBER) IS
184: SELECT line_no,ORDER_UM1, item_id
185: FROM po_ordr_dtl
186: WHERE po_id = vc_po_id AND
187: line_id = vc_line_id;
188:
189: CURSOR status_cur(vc_po_id NUMBER, vc_line_id NUMBER) IS

Line 191: FROM po_ordr_dtl

187: line_id = vc_line_id;
188:
189: CURSOR status_cur(vc_po_id NUMBER, vc_line_id NUMBER) IS
190: SELECT po_status
191: FROM po_ordr_dtl
192: WHERE po_id = vc_po_id AND
193: line_id = vc_line_id;
194:
195: CURSOR org_cur IS

Line 229: /* from the po_ordr_dtl table*/

225: FETCH po_org_cur INTO v_po_no, v_orgn_code;
226: CLOSE po_org_cur;
227:
228: /* obtain the line_no corresponding to the given po_id and line_id*/
229: /* from the po_ordr_dtl table*/
230:
231: OPEN line_no_cur(G_po_id, G_poline_id);
232: FETCH line_no_cur INTO v_line_no,v_order_um1,x_item_id;
233: CLOSE line_no_cur;