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 4308: FROM po_requisition_lines_all prl, po_req_distributions_all prd

4304: p_supply_source_type_id = inv_reservation_global.g_source_type_req) THEN
4305:
4306: SELECT count(1)
4307: INTO l_project_count
4308: FROM po_requisition_lines_all prl, po_req_distributions_all prd
4309: WHERE prl.requisition_header_id = p_supply_source_header_id
4310: AND prl.requisition_line_id = p_supply_source_line_id
4311: AND prl.requisition_line_id = prd.requisition_line_id
4312: group by prd.project_id, prd.task_id;

Line 4327: FROM po_requisition_lines_all prl, po_req_distributions_all prd

4323:
4324: IF((p_project_id is not null) AND (l_project_count = 1)) THEN
4325: SELECT MIN(prd.project_id), MIN(prd.task_id)
4326: INTO l_project_id, l_task_id
4327: FROM po_requisition_lines_all prl, po_req_distributions_all prd
4328: WHERE prl.requisition_header_id = p_supply_source_header_id
4329: AND prl.requisition_line_id = p_supply_source_line_id
4330: AND prl.requisition_line_id = prd.requisition_line_id;
4331: