DBA Data[Home] [Help]

APPS.WIP_RESOURCE_VALIDATIONS dependencies on BOM_DEPARTMENT_RESOURCES

Line 855: from bom_department_resources bdr

851: and ( br.disable_date > sysdate
852: or br.disable_date is null)
853: and br.organization_id = p_organization_id)
854: or not exists(select 1
855: from bom_department_resources bdr
856: where bdr.resource_id = p_resource_id_new
857: and bdr.department_id = wo.department_id)
858: );
859:

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