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_WORKORDER_UTIL_PKG dependencies on PO_REQUISITION_LINES_ALL

Line 920: FROM po_requisition_lines_all rql,

916: SELECT
917: rql.wip_entity_id,
918: rql.quantity quantity_ordered,
919: to_number(null) quantity_received
920: FROM po_requisition_lines_all rql,
921: po_requisition_headers_all rqh,
922: po_line_types plt
923: WHERE rql.requisition_header_id = rqh.requisition_header_id
924: AND rql.line_type_id = plt.line_type_id

Line 1221: FROM po_requisition_lines_all rql,

1217: SELECT
1218: rql.wip_entity_id,
1219: rql.quantity quantity_ordered,
1220: to_number(null) quantity_received
1221: FROM po_requisition_lines_all rql,
1222: po_requisition_headers_all rqh,
1223: po_line_types plt
1224: WHERE rql.requisition_header_id = rqh.requisition_header_id
1225: AND rql.line_type_id = plt.line_type_id

Line 1531: FROM po_requisition_lines_all rql,

1527: SELECT
1528: rql.wip_entity_id,
1529: rql.quantity quantity_ordered,
1530: to_number(null) quantity_received
1531: FROM po_requisition_lines_all rql,
1532: po_requisition_headers_all rqh,
1533: po_line_types plt
1534: WHERE rql.requisition_header_id = rqh.requisition_header_id
1535: AND rql.line_type_id = plt.line_type_id

Line 1732: FROM PO_REQUISITION_LINES_ALL PRL

1728: OR NVL(PLL.CLOSED_CODE,'N')='REJECTED'
1729: )
1730: UNION ALL
1731: SELECT 'PO/REQ Linked'
1732: FROM PO_REQUISITION_LINES_ALL PRL
1733: WHERE PRL.WIP_ENTITY_ID = p_wip_id
1734: AND PRL.DESTINATION_ORGANIZATION_ID = p_org_id
1735: AND NOT(
1736: NVL(PRL.CANCEL_FLAG,'N')='Y'