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_LINES_ALL

Line 3635: FROM po_distributions_all pd , po_headers_all ph,po_lines_all pl

3631: AND prla.wip_resource_seq_num is null
3632:
3633: UNION ALL
3634: SELECT SUM(nvl(pd.quantity_ordered,0)) req_qty
3635: FROM po_distributions_all pd , po_headers_all ph,po_lines_all pl
3636: WHERE pd.po_header_id = ph.po_header_id(+)
3637: AND upper(NVL(ph.authorization_status, 'APPROVED') ) not in ('CANCELLED', 'REJECTED','SYSTEM_SAVED')
3638: AND UPPER(NVL(pl.cancel_flag,'N')) <> 'Y'
3639: AND pd.po_line_id = pl.po_line_id(+)

Line 3692: FROM po_distributions_all pd , po_headers_all ph,po_lines_all pl

3688: AND prla.wip_resource_seq_num is null
3689:
3690: UNION ALL
3691: SELECT SUM(nvl(pd.quantity_ordered,0)) req_qty
3692: FROM po_distributions_all pd , po_headers_all ph,po_lines_all pl
3693: WHERE pd.po_header_id = ph.po_header_id(+)
3694: AND upper(NVL(ph.authorization_status, 'APPROVED') ) not in ('SYSTEM_SAVED')
3695: AND pd.po_line_id = pl.po_line_id(+)
3696: AND pd.wip_entity_id = l_eam_mat_req_rec.wip_entity_id

Line 4548: FROM po_distributions_all pd , po_headers_all ph,po_lines_all pl

4544: AND prla.wip_resource_seq_num = l_eam_direct_items_rec.direct_item_sequence_id
4545:
4546: UNION ALL
4547: SELECT SUM(nvl(pd.quantity_ordered,0)) req_qty
4548: FROM po_distributions_all pd , po_headers_all ph,po_lines_all pl
4549: WHERE pd.po_header_id = ph.po_header_id(+)
4550: AND upper(NVL(ph.authorization_status, 'APPROVED') ) not in ('CANCELLED', 'REJECTED','SYSTEM_SAVED')
4551: AND pd.po_line_id = pl.po_line_id(+)
4552: AND UPPER(NVL(pl.cancel_flag,'N')) <> 'Y'

Line 4603: FROM po_distributions_all pd , po_headers_all ph,po_lines_all pl

4599: AND prla.wip_resource_seq_num = l_eam_direct_items_rec.direct_item_sequence_id
4600:
4601: UNION ALL
4602: SELECT SUM(nvl(pd.quantity_ordered,0)) req_qty
4603: FROM po_distributions_all pd , po_headers_all ph,po_lines_all pl
4604: WHERE pd.po_header_id = ph.po_header_id(+)
4605: AND upper(NVL(ph.authorization_status, 'APPROVED') ) not in ('SYSTEM_SAVED')
4606: AND pd.po_line_id = pl.po_line_id(+)
4607: AND pd.wip_entity_id = l_eam_direct_items_rec.wip_entity_id