DBA Data[Home] [Help]

APPS.WIP_RESOURCE_VALIDATIONS dependencies on WIP_OPERATIONS

Line 826: from wip_job_dtls_interface wjdi, wip_operations wo

822:
823:
824: cursor c_invalid_rows is
825: select interface_id
826: from wip_job_dtls_interface wjdi, wip_operations wo
827: where wjdi.group_id = p_group_id
828: and wjdi.process_phase = wip_constants.ml_validation
829: and wjdi.process_status in (wip_constants.running,
830: wip_constants.warning)

Line 905: from bom_department_resources bdr, wip_operations wo

901: and ( br.disable_date > sysdate
902: or br.disable_date is null)
903: and br.organization_id = p_organization_id)
904: or not exists(select 1
905: from bom_department_resources bdr, wip_operations wo
906: where bdr.resource_id = p_resource_id_new
907: and wo.wip_entity_id = p_wip_entity_id
908: and wo.operation_seq_num = p_operation_seq_num
909: and wo.organization_id = p_organization_id