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.

[Home] [Help]

APPS.WIP_WS_LABOR_METRIC_PUB dependencies on BOM_RESOURCES

Line 276: bom_resources br

272: from per_all_people_f papf,
273: bom_resource_employees bre,
274: bom_dept_res_instances bdri,
275: bom_department_resources bdr,
276: bom_resources br
277: where papf.person_id = bre.person_id
278: and bre.instance_id = bdri.instance_id
279: and sysdate between papf.effective_start_date and nvl(papf.effective_end_date,sysdate+1)
280: and bre.resource_id = bdri.resource_id

Line 526: from wip_operation_resources wor,bom_resources br

522: where organization_id= org_id
523: and wip_entity_id= we_ent_id
524: and operation_seq_num= op_seq_num
525: and resource_seq_num = (select min(wor.resource_seq_num)
526: from wip_operation_resources wor,bom_resources br
527: where wor.organization_id= org_id
528: and wor.wip_entity_id= we_ent_id
529: and wor.operation_seq_num= op_seq_num
530: and WIP_WS_LABOR_METRIC_PUB.is_time_uom(wor.uom_code) = 1