APPS.PO_RCO_VALIDATION_GRP dependencies on PO_REQUISITION_LINES_ALL

Line 20: FROM po_requisition_lines_all

16: IS
17: CURSOR l_line_csr(hdr_id NUMBER) IS
18: SELECT requisition_line_id,
19: line_location_id
20: FROM po_requisition_lines_all
21: WHERE requisition_header_id = hdr_id;
22:
23: l_line_id NUMBER;
24: l_line_location_id NUMBER;

Line 90: FROM po_requisition_lines_all

86:
87: CURSOR l_line_csr(hdr_id NUMBER) IS
88: SELECT requisition_line_id,
89: line_location_id
90: FROM po_requisition_lines_all
91: WHERE requisition_header_id = hdr_id;
92:
93: l_line_id NUMBER;
94: l_line_location_id NUMBER;

Line 503: FROM po_requisition_lines_all

499: BEGIN
500:
501: SELECT Count(*)
502: INTO l_line_to_withdraw_count
503: FROM po_requisition_lines_all
504: WHERE REQUISITION_HEADER_ID = p_req_hdr_id
505: AND LINE_LOCATION_ID IS NULL
506: AND nvl(CANCEL_FLAG,'N') = 'N'
507: AND nvl(CLOSED_CODE,'OPEN') NOT IN ('FINALLY CLOSED');