APPS.PO_REQ_LINES_SV dependencies on PO_REQUISITION_HEADERS_ALL

Line 1114: --SQL Join: requisition_header_id from PO_REQUISITION_HEADERS_ALL

1110: --SQL Why: Requisition lines where any of the above applies cannot
1111: -- be placed on a purchasing document; those that fail all
1112: -- the above criteria can.
1113: --
1114: --SQL Join: requisition_header_id from PO_REQUISITION_HEADERS_ALL
1115: UPDATE po_requisition_lines_all prl
1116: SET prl.reqs_in_pool_flag =
1117: CASE
1118: WHEN NVL(prl.cancel_flag,'N') = 'Y'

Line 1125: FROM PO_REQUISITION_HEADERS_ALL prh

1121: OR NVL(prl.modified_by_agent_flag,'N') = 'Y'
1122: OR prl.at_sourcing_flag = 'Y'
1123: OR prl.source_type_code <> 'VENDOR'
1124: OR NVL((SELECT prh.authorization_status
1125: FROM PO_REQUISITION_HEADERS_ALL prh
1126: WHERE prh.requisition_header_id = prl.requisition_header_id)
1127: , 'INCOMPLETE') <> 'APPROVED'
1128: OR NVL((SELECT prh.contractor_status
1129: FROM PO_REQUISITION_HEADERS_ALL prh

Line 1129: FROM PO_REQUISITION_HEADERS_ALL prh

1125: FROM PO_REQUISITION_HEADERS_ALL prh
1126: WHERE prh.requisition_header_id = prl.requisition_header_id)
1127: , 'INCOMPLETE') <> 'APPROVED'
1128: OR NVL((SELECT prh.contractor_status
1129: FROM PO_REQUISITION_HEADERS_ALL prh
1130: WHERE prh.requisition_header_id = prl.requisition_header_id)
1131: , 'NOT APPLICABLE') = 'PENDING'
1132: THEN
1133: NULL

Line 1184: X_req_num po_requisition_headers_all.segment1%TYPE;

1180: X_req_line_id IN NUMBER) RETURN BOOLEAN IS
1181:
1182: X_progress VARCHAR2(3) := NULL;
1183: X_order_source_id po_system_parameters.order_source_id%TYPE;
1184: X_req_num po_requisition_headers_all.segment1%TYPE;
1185: X_oe_line_tbl OE_ORDER_IMPORT_INTEROP_PUB.LineId_Tbl_Type;
1186: X_oe_return VARCHAR2(30);
1187: X_oe_line_ctr NUMBER := 0;
1188:

Line 1211: FROM po_requisition_headers_all

1207: X_progress := '020';
1208:
1209: SELECT segment1
1210: INTO X_req_num
1211: FROM po_requisition_headers_all
1212: WHERE requisition_header_id = X_req_header_id;
1213:
1214: X_progress := '030';
1215: