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_LINE_TYPES

Line 922: po_line_types plt

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
925: AND upper(rqh.authorization_status) not in ('CANCELLED', 'REJECTED','SYSTEM_SAVED')
926: AND rql.line_location_id is NULL

Line 937: FROM po_line_types plt,

933: SELECT
934: pd.wip_entity_id,
935: sum(pd.quantity_ordered) quantity_ordered,
936: sum(pd.quantity_delivered) quantity_received
937: FROM po_line_types plt,
938: (
939: SELECT
940: pd1.wip_entity_id,
941: pd1.wip_operation_seq_num,

Line 1223: po_line_types plt

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
1226: AND upper(rqh.authorization_status) not in ('CANCELLED', 'REJECTED','SYSTEM_SAVED')
1227: AND rql.line_location_id is NULL

Line 1238: FROM po_line_types plt,

1234: SELECT
1235: pd.wip_entity_id,
1236: sum(pd.quantity_ordered) quantity_ordered,
1237: sum(pd.quantity_delivered) quantity_received
1238: FROM po_line_types plt,
1239: (
1240: SELECT
1241: pd1.wip_entity_id,
1242: pd1.wip_operation_seq_num,

Line 1533: po_line_types plt

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
1536: AND upper(rqh.authorization_status) not in ('CANCELLED', 'REJECTED','SYSTEM_SAVED')
1537: AND rql.line_location_id is NULL

Line 1548: FROM po_line_types plt,

1544: SELECT
1545: pd.wip_entity_id,
1546: sum(pd.quantity_ordered) quantity_ordered,
1547: sum(pd.quantity_delivered) quantity_received
1548: FROM po_line_types plt,
1549: (
1550: SELECT
1551: pd1.wip_entity_id,
1552: pd1.wip_operation_seq_num,