DBA Data[Home] [Help]

APPS.EAM_CREATEUPDATE_WO_PVT dependencies on WIP_OPERATION_RESOURCE_USAGE

Line 3176: FROM WIP_OPERATION_RESOURCE_USAGE woru

3172: CURSOR get_hours_details_csr IS
3173: SELECT ROUND(NVL(wor.usage_rate_or_amount * (1/l_uom_conv) *
3174: (DECODE (con.conversion_rate,'', 0, '0', 0, con.conversion_rate)),0),2) required_hours,
3175: (SELECT ROUND(NVL(SUM((woru.completion_date-woru.start_date)*24) ,0),2)
3176: FROM WIP_OPERATION_RESOURCE_USAGE woru
3177: WHERE woru.wip_entity_id = wor.wip_entity_id
3178: AND woru.organization_id = wor.organization_id
3179: AND woru.operation_seq_num = wor.operation_seq_num
3180: AND woru.resource_seq_num = wor.resource_seq_num