DBA Data[Home] [Help]

APPS.EAM_CREATEUPDATE_WO_PVT dependencies on WIP_OPERATION_RESOURCE_USAGE

Line 985: FROM WIP_OPERATION_RESOURCE_USAGE woru

981: CURSOR get_hours_details_csr IS
982: SELECT ROUND(NVL(wor.usage_rate_or_amount * (1/l_uom_conv) *
983: (DECODE (con.conversion_rate,'', 0, '0', 0, con.conversion_rate)),0),2) required_hours,
984: (SELECT ROUND(NVL(SUM((woru.completion_date-woru.start_date)*24) ,0),2)
985: FROM WIP_OPERATION_RESOURCE_USAGE woru
986: WHERE woru.wip_entity_id = wor.wip_entity_id
987: AND woru.organization_id = wor.organization_id
988: AND woru.operation_seq_num = wor.operation_seq_num
989: AND woru.resource_seq_num = wor.resource_seq_num