DBA Data[Home] [Help]

APPS.WIP_OPERATION_VALIDATE dependencies on WIP_OPERATION_RESOURCES

Line 367: from wip_operation_resources wor,

363: and wip_entity_id = p_wip_entity_id
364: and organization_id = p_organization_id
365: and department_id is not null
366: and exists (select 1
367: from wip_operation_resources wor,
368: wip_operations wo
369: where wo.wip_entity_id = wjdi.wip_entity_id
370: and wo.operation_seq_num = wjdi.operation_seq_num
371: and wo.organization_id = wjdi.organization_id

Line 412: from wip_operation_resources wor,

408: and wip_entity_id = p_wip_entity_id
409: and organization_id = p_organization_id
410: and department_id is not null
411: and exists (select 1
412: from wip_operation_resources wor,
413: wip_operations wo
414: where wo.wip_entity_id = wjdi.wip_entity_id
415: and wo.operation_seq_num = wjdi.operation_seq_num
416: and wo.organization_id = wjdi.organization_id