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

Line 3623: FROM po_requisition_lines_all prla , po_requisition_headers_all prha

3619: AND ((process_flag is null) or (Upper(Trim(process_flag)) = 'IN PROCESS'))
3620:
3621: UNION ALL
3622: SELECT SUM(nvl(prla.quantity,0)) req_qty
3623: FROM po_requisition_lines_all prla , po_requisition_headers_all prha
3624: WHERE prla.requisition_header_id = prha.requisition_header_id(+)
3625: AND upper(NVL(prha.authorization_status, 'APPROVED') ) not in ('CANCELLED', 'REJECTED','SYSTEM_SAVED')
3626: AND UPPER(NVL(prla.cancel_flag,'N')) <> 'Y'
3627: AND prla.wip_entity_id = l_eam_mat_req_rec.wip_entity_id

Line 3647: FROM po_requisition_lines_all prla , po_requisition_headers_all prha

3643: AND pl.item_id = l_eam_mat_req_rec.inventory_item_id
3644: AND pd.wip_resource_seq_num is null
3645: AND pd.line_location_id not in(
3646: SELECT nvl(prla.line_location_id,0)
3647: FROM po_requisition_lines_all prla , po_requisition_headers_all prha
3648: WHERE prla.requisition_header_id = prha.requisition_header_id(+)
3649: AND upper(NVL(prha.authorization_status, 'APPROVED') ) not in ('CANCELLED', 'REJECTED','SYSTEM_SAVED')
3650: AND UPPER(NVL(prla.cancel_flag,'N')) <> 'Y'
3651: AND prla.wip_entity_id =l_eam_mat_req_rec.wip_entity_id

Line 3681: FROM po_requisition_lines_all prla , po_requisition_headers_all prha

3677: AND ((process_flag is null) or (Upper(Trim(process_flag)) = 'IN PROCESS'))
3678:
3679: UNION ALL
3680: SELECT SUM(nvl(prla.quantity,0)) req_qty
3681: FROM po_requisition_lines_all prla , po_requisition_headers_all prha
3682: WHERE prla.requisition_header_id = prha.requisition_header_id(+)
3683: AND upper(NVL(prha.authorization_status, 'APPROVED') ) not in ('SYSTEM_SAVED')
3684: AND prla.wip_entity_id = l_eam_mat_req_rec.wip_entity_id
3685: AND prla.destination_organization_id = l_eam_mat_req_rec.organization_id

Line 3703: FROM po_requisition_lines_all prla , po_requisition_headers_all prha

3699: AND pl.item_id = l_eam_mat_req_rec.inventory_item_id
3700: AND pd.wip_resource_seq_num is null
3701: AND pd.line_location_id not in(
3702: SELECT nvl(prla.line_location_id,0)
3703: FROM po_requisition_lines_all prla , po_requisition_headers_all prha
3704: WHERE prla.requisition_header_id = prha.requisition_header_id(+)
3705: AND upper(NVL(prha.authorization_status, 'APPROVED') ) not in ('SYSTEM_SAVED')
3706: AND prla.wip_entity_id =l_eam_mat_req_rec.wip_entity_id
3707: AND prla.destination_organization_id = l_eam_mat_req_rec.organization_id

Line 4536: FROM po_requisition_lines_all prla , po_requisition_headers_all prha

4532: AND ((process_flag is null) or (Upper(Trim(process_flag)) = 'IN PROCESS'))
4533:
4534: UNION ALL
4535: SELECT SUM(nvl(prla.quantity,0)) req_qty
4536: FROM po_requisition_lines_all prla , po_requisition_headers_all prha
4537: WHERE prla.requisition_header_id = prha.requisition_header_id(+)
4538: AND upper(NVL(prha.authorization_status, 'APPROVED') ) not in ('CANCELLED', 'REJECTED','SYSTEM_SAVED')
4539: AND UPPER(NVL(prla.cancel_flag,'N')) <> 'Y'
4540: AND prla.wip_entity_id =l_eam_direct_items_rec.wip_entity_id

Line 4560: FROM po_requisition_lines_all prla , po_requisition_headers_all prha

4556: AND pl.item_id is null
4557: AND pd.wip_resource_seq_num = l_eam_direct_items_rec.direct_item_sequence_id
4558: AND pd.line_location_id not in(
4559: SELECT nvl(prla.line_location_id,0)
4560: FROM po_requisition_lines_all prla , po_requisition_headers_all prha
4561: WHERE prla.requisition_header_id = prha.requisition_header_id(+)
4562: AND upper(NVL(prha.authorization_status, 'APPROVED') ) not in ('CANCELLED', 'REJECTED','SYSTEM_SAVED')
4563: AND UPPER(NVL(prla.cancel_flag,'N')) <> 'Y'
4564: AND prla.wip_entity_id =l_eam_direct_items_rec.wip_entity_id

Line 4592: FROM po_requisition_lines_all prla , po_requisition_headers_all prha

4588: AND ((process_flag is null) or (Upper(Trim(process_flag)) = 'IN PROCESS'))
4589:
4590: UNION ALL
4591: SELECT SUM(nvl(prla.quantity,0)) req_qty
4592: FROM po_requisition_lines_all prla , po_requisition_headers_all prha
4593: WHERE prla.requisition_header_id = prha.requisition_header_id(+)
4594: AND upper(NVL(prha.authorization_status, 'APPROVED') ) not in ('SYSTEM_SAVED')
4595: AND prla.wip_entity_id =l_eam_direct_items_rec.wip_entity_id
4596: AND prla.destination_organization_id = l_eam_direct_items_rec.organization_id

Line 4614: FROM po_requisition_lines_all prla , po_requisition_headers_all prha

4610: AND pl.item_id is null
4611: AND pd.wip_resource_seq_num = l_eam_direct_items_rec.direct_item_sequence_id
4612: AND pd.line_location_id not in(
4613: SELECT nvl(prla.line_location_id,0)
4614: FROM po_requisition_lines_all prla , po_requisition_headers_all prha
4615: WHERE prla.requisition_header_id = prha.requisition_header_id(+)
4616: AND upper(NVL(prha.authorization_status, 'APPROVED') ) not in ('SYSTEM_SAVED')
4617: AND prla.wip_entity_id =l_eam_direct_items_rec.wip_entity_id
4618: AND prla.destination_organization_id = l_eam_direct_items_rec.organization_id