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.INV_RESERVATION_VALIDATE_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 440: FROM po_requisition_lines_all

436: /*** End R12 }} ***/
437:
438: CURSOR c_req_supply IS
439: SELECT 'Y'
440: FROM po_requisition_lines_all
441: WHERE requisition_line_id = p_supply_source_line_id
442: AND requisition_header_id = p_supply_source_header_id;
443:
444: BEGIN

Line 4472: FROM po_requisition_lines_all prl, po_req_distributions_all prd

4468: p_supply_source_type_id = inv_reservation_global.g_source_type_req) THEN
4469:
4470: SELECT count(1)
4471: INTO l_project_count
4472: FROM po_requisition_lines_all prl, po_req_distributions_all prd
4473: WHERE prl.requisition_header_id = p_supply_source_header_id
4474: AND prl.requisition_line_id = p_supply_source_line_id
4475: AND prl.requisition_line_id = prd.requisition_line_id
4476: group by prd.project_id, prd.task_id;

Line 4491: FROM po_requisition_lines_all prl, po_req_distributions_all prd

4487:
4488: IF((p_project_id is not null) AND (l_project_count = 1)) THEN
4489: SELECT MIN(prd.project_id), MIN(prd.task_id)
4490: INTO l_project_id, l_task_id
4491: FROM po_requisition_lines_all prl, po_req_distributions_all prd
4492: WHERE prl.requisition_header_id = p_supply_source_header_id
4493: AND prl.requisition_line_id = p_supply_source_line_id
4494: AND prl.requisition_line_id = prd.requisition_line_id;
4495: