APPS.PO_REQ_LINES_SV dependencies on PO_REQUISITION_HEADERS

Line 242: FROM PO_REQUISITION_HEADERS PORH, PO_REQUISITION_LINES PORL,

238: --Toju George 08/31/2000
239: --Modified the call to procedure to replace req_num and line_num with ids.
240: /* SELECT COUNT(1)
241: INTO X_row_exists
242: FROM PO_REQUISITION_HEADERS PORH, PO_REQUISITION_LINES PORL,
243: PO_SYSTEM_PARAMETERS POSP
244: WHERE PORH.requisition_header_id = X_req_header_id
245: AND PORL.requisition_line_id = nvl(X_req_line_id, PORL.requisition_line_id)
246: AND PORH.requisition_header_id = PORL.requisition_header_id

Line 254: FROM PO_REQUISITION_HEADERS PORH, PO_REQUISITION_LINES PORL,

250: PORL.line_num ) > 0 ;
251: */
252: SELECT COUNT(1)
253: INTO X_row_exists
254: FROM PO_REQUISITION_HEADERS PORH, PO_REQUISITION_LINES PORL,
255: PO_SYSTEM_PARAMETERS POSP
256: WHERE PORH.requisition_header_id = X_req_header_id
257: AND PORL.requisition_line_id = nvl(X_req_line_id, PORL.requisition_line_id)
258: AND PORH.requisition_header_id = PORL.requisition_header_id

Line 1040: FROM po_requisition_headers

1036: only if it is NULL. Need not update the flag, if it is already 'Y'or 'N' */
1037:
1038: SELECT transferred_to_oe_flag
1039: INTO x_flag
1040: FROM po_requisition_headers
1041: WHERE requisition_header_id = x_req_hdr_id;
1042:
1043: IF (x_flag = 'Y' or x_flag = 'N') then
1044: x_transferred_to_oe_flag := x_flag;

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: