DBA Data[Home] [Help]

APPS.PO_QUOTES_SV dependencies on PO_REQUISITION_LINES

Line 86: FROM po_requisition_lines prl

82: ** If it is, display message and prevent delete.
83: */
84: SELECT MAX('N')
85: INTO X_delete_test
86: FROM po_requisition_lines prl
87: WHERE prl.blanket_po_header_id = X_po_header_id;
88:
89: IF (nvl(X_delete_test,'Y') = 'Y') THEN
90: X_allow_delete := TRUE;

Line 164: FROM po_requisition_lines prl

160: AND pol.from_line_id = X_po_line_id;
161:
162: CURSOR C_ON_REQ is
163: SELECT prl.blanket_po_line_num
164: FROM po_requisition_lines prl
165: WHERE prl.BLANKET_PO_HEADER_ID = X_po_header_id
166: AND prl.BLANKET_PO_LINE_NUM = X_po_line_num;
167:
168: BEGIN