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_COMMON_UTILITIES_PVT dependencies on WIP_OP_RESOURCE_INSTANCES

Line 1632: wip_op_resource_instances wori,

1628: FROM wip_entities we,
1629: wip_discrete_jobs wdj,
1630: wip_operations wo,
1631: wip_operation_resources wor,
1632: wip_op_resource_instances wori,
1633: bom_resource_employees bre,
1634: (SELECT wip_entity_id,
1635: operation_seq_num,
1636: resource_seq_num,

Line 1688: wip_op_resource_instances wori,

1684: FROM wip_entities we,
1685: wip_discrete_jobs wdj,
1686: wip_operations wo,
1687: wip_operation_resources wor,
1688: wip_op_resource_instances wori,
1689: bom_resource_employees bre,
1690: (SELECT wip_entity_id,
1691: operation_seq_num,
1692: resource_seq_num,

Line 1745: wip_op_resource_instances wori,

1741: FROM wip_entities we,
1742: wip_discrete_jobs wdj,
1743: wip_operations wo,
1744: wip_operation_resources wor,
1745: wip_op_resource_instances wori,
1746: bom_resource_employees bre,
1747: (SELECT wip_entity_id,
1748: operation_seq_num,
1749: resource_seq_num,

Line 1813: FROM wip_op_resource_instances wori

1809: SUM(completion_date - start_date) usage
1810: FROM wip_operation_resource_usage woru
1811: WHERE (woru.instance_id IS NOT NULL OR NOT EXISTS
1812: (SELECT 1
1813: FROM wip_op_resource_instances wori
1814: WHERE woru.wip_entity_id = wori.wip_entity_id
1815: AND woru.operation_seq_num = wori.operation_seq_num
1816: AND woru.resource_seq_num = wori.resource_seq_num
1817: )

Line 1890: FROM wip_op_resource_instances wori

1886: SUM(completion_date - start_date) usage
1887: FROM wip_operation_resource_usage woru
1888: WHERE (woru.instance_id IS NOT NULL OR NOT EXISTS
1889: (SELECT 1
1890: FROM wip_op_resource_instances wori
1891: WHERE woru.wip_entity_id = wori.wip_entity_id
1892: AND woru.operation_seq_num = wori.operation_seq_num
1893: AND woru.resource_seq_num = wori.resource_seq_num
1894: )

Line 1966: FROM wip_op_resource_instances wori

1962: SUM(completion_date - start_date) usage
1963: FROM wip_operation_resource_usage woru
1964: WHERE (woru.instance_id IS NOT NULL OR NOT EXISTS
1965: (SELECT 1
1966: FROM wip_op_resource_instances wori
1967: WHERE woru.wip_entity_id = wori.wip_entity_id
1968: AND woru.operation_seq_num = wori.operation_seq_num
1969: AND woru.resource_seq_num = wori.resource_seq_num
1970: )