DBA Data[Home] [Help]

APPS.EAM_ASSIGN_EMP_PUB dependencies on WIP_OP_RESOURCE_INSTANCES

Line 1421: FROM wip_op_resource_instances wori

1417: AND woru.repetitive_schedule_id IS NULL
1418: AND woru.resource_seq_num = p_res_seq_num
1419: UNION
1420: SELECT ROUND(NVL((wori.completion_date - wori.start_date)*24,0),2) as assigned_hours
1421: FROM wip_op_resource_instances wori
1422: WHERE wori.serial_number IS NULL
1423: AND wori.instance_id IS NOT NULL
1424: AND wori.wip_entity_id = p_wip_entity_id
1425: AND wori.operation_seq_num = p_op_seq_num