eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_REQ_LINES_SV dependencies on PO_REQUISITION_HEADERS_ALL

Line 755: FROM po_requisition_headers_all rh

751: SET rl.line_location_id = NULL,
752: --reqs_in_pool_flag = 'Y', -- Bug 2781027 resetting the reqs in pool flag
753: --Bug 9976204.Set the reqs_in_pool_flag back to Y only if the Req is APPROVED or PRE-APPROVED
754: rl.reqs_in_pool_flag = (SELECT Decode(rh.authorization_status,'APPROVED','Y','PRE-APPROVED','Y',rl.reqs_in_pool_flag)
755: FROM po_requisition_headers_all rh
756: WHERE rh.requisition_header_id = rl.requisition_header_id),
757: rl.last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)
758: rl.last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)
759: rl.last_update_date = sysdate -- Bug5623016 (updating who column)

Line 793: FROM po_requisition_headers_all rh

789: SET rl.line_location_id = NULL,
790: --reqs_in_pool_flag = 'Y', -- Bug 2781027
791: --Bug 9976204.Set the reqs_in_pool_flag back to Y only if the Req is APPROVED or PRE-APPROVED
792: rl.reqs_in_pool_flag = (SELECT Decode(rh.authorization_status,'APPROVED','Y','PRE-APPROVED','Y',rl.reqs_in_pool_flag)
793: FROM po_requisition_headers_all rh
794: WHERE rh.requisition_header_id = rl.requisition_header_id),
795: rl.last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)
796: rl.last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)
797: rl.last_update_date = sysdate -- Bug5623016 (upda ting who column)

Line 831: FROM po_requisition_headers_all rh

827: SET rl.line_location_id = NULL,
828: -- reqs_in_pool_flag = 'Y', -- Bug 2781027
829: --Bug 9976204.Set the reqs_in_pool_flag back to Y only if the Req is APPROVED or PRE-APPROVED
830: rl.reqs_in_pool_flag = (SELECT Decode(rh.authorization_status,'APPROVED','Y','PRE-APPROVED','Y',rl.reqs_in_pool_flag)
831: FROM po_requisition_headers_all rh
832: WHERE rh.requisition_header_id = rl.requisition_header_id
833: -- Bug 15875473
834: AND rl.line_location_id in (SELECT pll.line_location_id FROM po_line_locations_all pll WHERE
835: pll.po_line_id = X_entity_id)

Line 876: FROM po_requisition_headers_all rh

872: SET rl.line_location_id = NULL,
873: --reqs_in_pool_flag = 'Y', -- Bug 2781027
874: --Bug 9976204.Set the reqs_in_pool_flag back to Y only if the Req is APPROVED or PRE-APPROVED
875: rl.reqs_in_pool_flag = (SELECT Decode(rh.authorization_status,'APPROVED','Y','PRE-APPROVED','Y',rl.reqs_in_pool_flag)
876: FROM po_requisition_headers_all rh
877: WHERE rh.requisition_header_id = rl.requisition_header_id),
878: rl.last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)
879: rl.last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)
880: rl.last_update_date = SYSDATE -- Bug5623016 (updating who column)

Line 1256: --SQL Join: requisition_header_id from PO_REQUISITION_HEADERS_ALL

1252: --SQL Why: Requisition lines where any of the above applies cannot
1253: -- be placed on a purchasing document; those that fail all
1254: -- the above criteria can.
1255: --
1256: --SQL Join: requisition_header_id from PO_REQUISITION_HEADERS_ALL
1257: UPDATE po_requisition_lines_all prl
1258: SET prl.reqs_in_pool_flag =
1259: CASE
1260: WHEN NVL(prl.cancel_flag,'N') = 'Y'

Line 1268: FROM PO_REQUISITION_HEADERS_ALL prh

1264: OR NVL(prl.modified_by_agent_flag,'N') = 'Y'
1265: OR prl.at_sourcing_flag = 'Y'
1266: OR prl.source_type_code <> 'VENDOR'
1267: OR NVL((SELECT prh.authorization_status
1268: FROM PO_REQUISITION_HEADERS_ALL prh
1269: WHERE prh.requisition_header_id = prl.requisition_header_id)
1270: , 'INCOMPLETE') <> 'APPROVED'
1271: OR NVL((SELECT prh.contractor_status
1272: FROM PO_REQUISITION_HEADERS_ALL prh

Line 1272: FROM PO_REQUISITION_HEADERS_ALL prh

1268: FROM PO_REQUISITION_HEADERS_ALL prh
1269: WHERE prh.requisition_header_id = prl.requisition_header_id)
1270: , 'INCOMPLETE') <> 'APPROVED'
1271: OR NVL((SELECT prh.contractor_status
1272: FROM PO_REQUISITION_HEADERS_ALL prh
1273: WHERE prh.requisition_header_id = prl.requisition_header_id)
1274: , 'NOT APPLICABLE') = 'PENDING'
1275: OR DECODE(
1276: (select prh.clm_mipr_type

Line 1277: from po_requisition_headers_all prh

1273: WHERE prh.requisition_header_id = prl.requisition_header_id)
1274: , 'NOT APPLICABLE') = 'PENDING'
1275: OR DECODE(
1276: (select prh.clm_mipr_type
1277: from po_requisition_headers_all prh
1278: where prh.requisition_header_id = prl.requisition_header_id),
1279: 'MIPR_OWN', NVL((select prh.clm_mipr_acknowledged_flag
1280: from po_requisition_headers_all prh
1281: where prh.requisition_header_id = prl.requisition_header_id),'N'),

Line 1280: from po_requisition_headers_all prh

1276: (select prh.clm_mipr_type
1277: from po_requisition_headers_all prh
1278: where prh.requisition_header_id = prl.requisition_header_id),
1279: 'MIPR_OWN', NVL((select prh.clm_mipr_acknowledged_flag
1280: from po_requisition_headers_all prh
1281: where prh.requisition_header_id = prl.requisition_header_id),'N'),
1282: 'MIPR_OTHERS', (select 'Y'
1283: from po_requisition_headers_all prh
1284: where prh.requisition_header_id = prl.requisition_header_id

Line 1283: from po_requisition_headers_all prh

1279: 'MIPR_OWN', NVL((select prh.clm_mipr_acknowledged_flag
1280: from po_requisition_headers_all prh
1281: where prh.requisition_header_id = prl.requisition_header_id),'N'),
1282: 'MIPR_OTHERS', (select 'Y'
1283: from po_requisition_headers_all prh
1284: where prh.requisition_header_id = prl.requisition_header_id
1285: AND ICX_DATATEMPLATE_PKG.GET_MIPR_ACCEPTANCE_STATUS(
1286: prl.requisition_header_id) = 'ACCEPT'), 'Y') <> 'Y'
1287:

Line 1340: X_req_num po_requisition_headers_all.segment1%TYPE;

1336: X_req_line_id IN NUMBER) RETURN BOOLEAN IS
1337:
1338: X_progress VARCHAR2(3) := NULL;
1339: X_order_source_id po_system_parameters.order_source_id%TYPE;
1340: X_req_num po_requisition_headers_all.segment1%TYPE;
1341: X_oe_line_tbl OE_ORDER_IMPORT_INTEROP_PUB.LineId_Tbl_Type;
1342: X_oe_return VARCHAR2(30);
1343: X_oe_line_ctr NUMBER := 0;
1344:

Line 1367: FROM po_requisition_headers_all

1363: X_progress := '020';
1364:
1365: SELECT segment1
1366: INTO X_req_num
1367: FROM po_requisition_headers_all
1368: WHERE requisition_header_id = X_req_header_id;
1369:
1370: X_progress := '030';
1371: