DBA Data[Home] [Help]

APPS.PO_REQ_DIST_SV dependencies on PO_REQUISITION_LINES

Line 183: FROM po_requisition_lines PORL

179: SET gl_cancelled_date = nvl(X_gl_cancelled_date, gl_cancelled_date),
180: gl_closed_date = nvl(X_gl_closed_date, gl_closed_date)
181: WHERE requisition_line_id IN
182: (SELECT requisition_line_id
183: FROM po_requisition_lines PORL
184: WHERE PORL.requisition_header_id = X_req_header_id
185: AND PORL.requisition_line_id =
186: nvl(X_req_line_id, PORL.requisition_line_id));
187: ELSE

Line 276: FROM po_requisition_lines

272: x_progress := '010';
273:
274: SELECT quantity
275: INTO x_orig_line_quantity
276: FROM po_requisition_lines
277: WHERE requisition_line_id = x_orig_req_line_id;
278:
279: -- dbms_output.put_line ('Original Line quantity: ' ||
280: -- bug1555260 to_char(x_orig_line_quantity));