DBA Data[Home] [Help]

APPS.PO_QUOTES_SV dependencies on PO_LINES

Line 58: FROM po_lines pol

54: ** If it is, display message and prevent delete.
55: */
56: SELECT MAX('N')
57: INTO X_delete_test
58: FROM po_lines pol
59: WHERE pol.from_header_id = X_po_header_id;
60:
61: x_progress := '020';
62:

Line 158: FROM po_lines pol

154: x_sourced NUMBER := '';
155:
156: CURSOR C_ON_PO is
157: SELECT pol.po_line_id
158: FROM po_lines pol
159: WHERE pol.from_header_id = X_po_header_id
160: AND pol.from_line_id = X_po_line_id;
161:
162: CURSOR C_ON_REQ is

Line 366: FROM po_lines pol

362: ** Check to see if quotation is referenced on a purchase order.
363: */
364: SELECT MAX('Y')
365: INTO X_quote_referenced
366: FROM po_lines pol
367: WHERE pol.from_header_id = X_po_header_id;
368:
369: x_progress := '020';
370: