DBA Data[Home] [Help]

APPS.WIP_WS_LABOR_METRIC_PUB dependencies on WIP_ENTITIES

Line 378: wip_entities we

374: decode(wrat.action_flag,2,-wrat.duration,wrat.duration) as duration,
375: wrat.uom_code
376: from wip_resource_actual_times wrat,
377: wip_operations wo,
378: wip_entities we
379: where wrat.organization_id = org_id
380: and wrat.organization_id= wo.organization_id
381: and wrat.wip_entity_id = wo.wip_entity_id
382: and we.organization_id = wo.organization_id

Line 405: wip_entities we

401: wrat.operation_seq_num as operation_seq_num,
402: get_index_for_date(wrat.start_date,wrat.organization_id,wo.department_id,res_id) as emp_index
403: from wip_resource_actual_times wrat,
404: wip_operations wo,
405: wip_entities we
406: where wrat.organization_id = org_id
407: and wrat.organization_id= wo.organization_id
408: and wrat.wip_entity_id = wo.wip_entity_id
409: and we.organization_id = wo.organization_id

Line 471: wip_entities we

467: get_index_for_date(wmt.transaction_date,wmt.organization_id,wo.department_id,res_id) as emp_index
468: from
469: wip_move_transactions wmt,
470: wip_operations wo,
471: wip_entities we
472: where
473: wo.organization_id = org_id
474: and wo.organization_id = wmt.organization_id
475: and wo.organization_id = we.organization_id