APPS.WIP_WS_LABOR_METRIC_PUB dependencies on WIP_ENTITIES

Line 388: wip_entities we

384: select wrat.start_date as actual_date,
385: decode(wrat.action_flag,2,-wrat.duration,wrat.duration) as duration,
386: wrat.uom_code
387: from wip_resource_actual_times wrat,
388: wip_entities we
389: where wrat.organization_id = org_id
390: and we.organization_id = wrat.organization_id
391: and we.wip_entity_id = wrat.wip_entity_id
392: and we.entity_type = 1

Line 413: wip_entities we

409: select distinct wrat.wip_entity_id as wip_entity_id,
410: wrat.operation_seq_num as operation_seq_num,
411: get_index_for_date(wrat.start_date,wrat.organization_id,dept_id,res_id) as emp_index
412: from wip_resource_actual_times wrat,
413: wip_entities we
414: where wrat.organization_id = org_id
415: and we.organization_id = wrat.organization_id
416: and we.wip_entity_id = wrat.wip_entity_id
417: and we.entity_type=1

Line 477: wip_entities we

473: get_index_for_date(wmt.transaction_date,wmt.organization_id,dep_id,res_id) as emp_index
474: from
475: wip_move_transactions wmt,
476: wip_operations wo,
477: wip_entities we
478: where
479: wo.organization_id = org_id
480: and wo.organization_id = wmt.organization_id
481: and wo.organization_id = we.organization_id