DBA Data[Home] [Help]

APPS.EAM_RES_INST_VALIDATE_PVT dependencies on WIP_OPERATION_RESOURCES

Line 241: from wip_operation_resources wor

237: if (p_eam_res_inst_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
238:
239: select 1
240: into g_dummy
241: from wip_operation_resources wor
242: where wor.organization_id = p_eam_res_inst_rec.organization_id
243: and wor.wip_entity_id = p_eam_res_inst_rec.wip_entity_id
244: and wor.operation_seq_num = p_eam_res_inst_rec.operation_seq_num
245: and wor.resource_seq_num = p_eam_res_inst_rec.resource_seq_num;

Line 286: wip_operation_resources wor,

282:
283: select 1 into g_dummy from
284: bom_dept_res_instances bdri,
285: bom_department_resources bdr,
286: wip_operation_resources wor,
287: wip_operations wo where
288: wor.wip_entity_id = p_eam_res_inst_rec.wip_entity_id
289: and wor.organization_id = p_eam_res_inst_rec.organization_id
290: and wor.operation_seq_num = p_eam_res_inst_rec.operation_seq_num

Line 435: from wip_operation_resources

431: l_count_wcti NUMBER :=0;
432: l_resource_id NUMBER;
433:
434: CURSOR res_inst IS select RESOURCE_id
435: from wip_operation_resources
436: where wip_entity_id = p_eam_res_inst_rec.wip_entity_id
437: and operation_seq_num = p_eam_res_inst_rec.operation_seq_num
438: and resource_seq_num = p_eam_res_inst_rec.resource_seq_num;
439: begin