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_WS_LABOR_METRIC_PUB dependencies on WIP_OPERATION_RESOURCES

Line 514: from wip_operation_resources

510: res_id number,
511: move_qty number)
512: is
513: select usage_rate_or_amount *decode(sign(move_qty),-1,0,move_qty) usage_rate,uom_code,basis_type, 1 resource_pick
514: from wip_operation_resources
515: where organization_id= org_id
516: and wip_entity_id= we_ent_id
517: and operation_seq_num= op_seq_num
518: and resource_id = res_id

Line 521: from wip_operation_resources wor

517: and operation_seq_num= op_seq_num
518: and resource_id = res_id
519: union all
520: select usage_rate_or_amount *decode(sign(move_qty),-1,0,move_qty) usage_rate,uom_code,basis_type, 2 resource_pick
521: from wip_operation_resources wor
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)

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