DBA Data[Home] [Help]

APPS.EAM_RES_INST_VALIDATE_PVT dependencies on WIP_OPERATIONS

Line 200: from wip_operations wo

196: if (p_eam_res_inst_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
197:
198: select 1
199: into g_dummy
200: from wip_operations wo
201: where wo.organization_id = p_eam_res_inst_rec.organization_id
202: and wo.wip_entity_id = p_eam_res_inst_rec.wip_entity_id
203: and wo.operation_seq_num = p_eam_res_inst_rec.operation_seq_num;
204:

Line 287: wip_operations wo where

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
291: and wor.resource_seq_num = p_eam_res_inst_rec.resource_seq_num