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.WIP_UPDATE_SETUP_RESOURCES dependencies on WIP_OPERATIONS

Line 100: wip_operations wo

96: wor.setup_id,
97: nvl(wo.quantity_running,0)+nvl(wo.quantity_completed,0) processed_qty,
98: wor.start_date start_date
99: from wip_operation_resources wor,
100: wip_operations wo
101: where wor.start_date >= p_completion_date
102: and wor.resource_id = p_resource_id
103: and wor.parent_resource_seq is null
104: and wo.wip_entity_id = wor.wip_entity_id

Line 135: wip_operations wo

131: nvl(wo.quantity_running,0)+nvl(wo.quantity_completed,0) processed_qty,
132: wor1.start_date start_date
133: from wip_op_resource_instances wori1,
134: wip_operation_resources wor1,
135: wip_operations wo
136: where wor1.wip_entity_id = wori1.wip_entity_id
137: and wor1.operation_seq_num = wori1.operation_seq_num
138: and wor1.resource_seq_num = wori1.resource_seq_num
139: and wori1.start_date >= p_completion_date

Line 208: wip_operations wo

204: l_resource_id,
205: l_dept_id,
206: l_res_completion_date
207: from wip_operation_resources wor,
208: wip_operations wo
209: where wor.wip_entity_id = p_wip_entity_id
210: and wor.organization_id = p_organization_id
211: and wor.operation_seq_num = p_operation_seq
212: and wor.resource_seq_num = p_resource_seq