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_UTIL_PVT dependencies on PO_LINES_ALL

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

622: AND prla.wip_resource_seq_num = l_di_record.direct_item_sequence_id
623:
624: UNION ALL
625: SELECT SUM(nvl(pd.quantity_ordered,0)) req_qty
626: FROM po_distributions_all pd , po_headers_all ph,po_lines_all pl
627: WHERE pd.po_header_id = ph.po_header_id(+)
628: AND upper(NVL(ph.authorization_status, 'APPROVED') ) not in ('CANCELLED', 'REJECTED','SYSTEM_SAVED')
629: AND pd.po_line_id = pl.po_line_id(+)
630: AND UPPER(NVL(pl.cancel_flag,'N')) <> 'Y'

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

677: AND prla.wip_resource_seq_num = l_di_record.direct_item_sequence_id
678:
679: UNION ALL
680: SELECT SUM(nvl(pd.quantity_ordered,0)) req_qty
681: FROM po_distributions_all pd , po_headers_all ph,po_lines_all pl
682: WHERE pd.po_header_id = ph.po_header_id(+)
683: AND upper(NVL(ph.authorization_status, 'APPROVED') ) not in ('SYSTEM_SAVED')
684: AND pd.po_line_id = pl.po_line_id(+)
685: AND pd.wip_entity_id = l_di_record.wip_entity_id

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

740: AND prla.wip_resource_seq_num is null
741:
742: UNION ALL
743: SELECT SUM(nvl(pd.quantity_ordered,0)) req_qty
744: FROM po_distributions_all pd , po_headers_all ph,po_lines_all pl
745: WHERE pd.po_header_id = ph.po_header_id(+)
746: AND upper(NVL(ph.authorization_status, 'APPROVED') ) not in ('CANCELLED', 'REJECTED','SYSTEM_SAVED')
747: AND UPPER(NVL(pl.cancel_flag,'N')) <> 'Y'
748: AND pd.po_line_id = pl.po_line_id(+)

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

798: AND prla.wip_resource_seq_num is null
799:
800: UNION ALL
801: SELECT SUM(nvl(pd.quantity_ordered,0)) req_qty
802: FROM po_distributions_all pd , po_headers_all ph,po_lines_all pl
803: WHERE pd.po_header_id = ph.po_header_id(+)
804: AND upper(NVL(ph.authorization_status, 'APPROVED') ) not in ('SYSTEM_SAVED')
805: AND pd.po_line_id = pl.po_line_id(+)
806: AND pd.wip_entity_id = l_di_record.wip_entity_id