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 495: FROM po_requisition_lines_all

491: BEGIN
492:
493: SELECT Count(*)
494: INTO l_line_to_withdraw_count
495: FROM po_requisition_lines_all
496: WHERE REQUISITION_HEADER_ID = p_req_hdr_id
497: AND LINE_LOCATION_ID IS NULL
498: AND nvl(CANCEL_FLAG,'N') = 'N'
499: AND nvl(CLOSED_CODE,'OPEN') NOT IN ('FINALLY CLOSED');