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 907: from bom_department_resources bdr, wip_operations wo

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