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 1631: wip_op_resource_instances wori,

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

Line 1687: wip_op_resource_instances wori,

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

Line 1744: wip_op_resource_instances wori,

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

Line 1812: FROM wip_op_resource_instances wori

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

Line 1889: FROM wip_op_resource_instances wori

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

Line 1965: FROM wip_op_resource_instances wori

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