APPS.EAM_ASSIGN_EMP_PUB dependencies on WIP_OPERATION_RESOURCES

Line 816: FROM wip_operation_resources wor

812: ),'Disable')
813: ) AS Enable_Row_Switcher ,
814: (
815: SELECT ROUND(SUM(wor.usage_rate_or_amount),2)
816: FROM wip_operation_resources wor
817: WHERE wor.wip_entity_id = woru.wip_entity_id
818: AND wor.organization_id = woru.organization_id
819: AND wor.operation_seq_num = woru.operation_seq_num
820: AND wor.resource_seq_num = woru.resource_seq_num

Line 865: FROM wip_operation_resources wor

861: wor.start_date as start_date,
862: wor.completion_date as completion_date,
863: ROUND(((wor.completion_date - wor.start_date)*24),2) as duration,
864: wor.resource_id as context_res_id
865: FROM wip_operation_resources wor
866: WHERE wor.wip_entity_id = p_wip_entity_id
867: AND wor.operation_seq_num = p_operation_seq_num
868: AND wor.resource_seq_num = p_resource_seq_num
869: AND wor.organization_id= p_organization_id

Line 1319: FROM wip_operation_resources wor

1315: ),'DisableWOUpdate')
1316: ) AS Update_Switcher ,
1317: (
1318: SELECT ROUND(SUM(wor.usage_rate_or_amount),2)
1319: FROM wip_operation_resources wor
1320: WHERE wor.wip_entity_id = woru.wip_entity_id
1321: AND wor.organization_id = woru.organization_id
1322: AND wor.operation_seq_num = woru.operation_seq_num
1323: AND wor.resource_seq_num = woru.resource_seq_num

Line 1400: FROM wip_operation_resources wor, bom_resources br

1396: AND wo.repetitive_schedule_id IS NULL;
1397:
1398: CURSOR l_res_csr_type(p_wip_entity_id IN NUMBER,p_organization_id IN NUMBER,p_op_seq_num IN NUMBER) IS
1399: SELECT wor.resource_seq_num , wor.usage_rate_or_amount
1400: FROM wip_operation_resources wor, bom_resources br
1401: WHERE wor.wip_entity_id = p_wip_entity_id
1402: AND wor.operation_seq_num = p_op_seq_num
1403: AND wor.ORGANIZATION_ID = p_organization_id
1404: AND wor.repetitive_schedule_id IS NULL