DBA Data[Home] [Help]

APPS.WIP_WS_LABOR_METRIC_PUB dependencies on WIP_OPERATIONS

Line 425: /* cursor to get all records from wip_move_transactions, wip_operations for obtaining completed quantity */

421: and wrat.wip_entity_id is not null
422: and wrat.duration is not null
423: and wrat.start_date between start_time and end_time;
424:
425: /* cursor to get all records from wip_move_transactions, wip_operations for obtaining completed quantity */
426: /* Modified for Bug 7010115. */
427: -- Lot based jobs should not be considered for earned hours. So added condition on entity_type.
428: cursor eh_records(org_id number,
429: start_time date,

Line 476: wip_operations wo,

472: 0) as move_qty,
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