DBA Data[Home] [Help]

APPS.WIP_WS_LABOR_METRIC_PUB dependencies on WIP_MOVE_TRANSACTIONS

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

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

Line 469: wip_move_transactions wmt,

465: else 0 end),
466: 0) as move_qty,
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