DBA Data[Home] [Help]

APPS.WIP_RESOURCE_VALIDATIONS dependencies on BOM_DEPARTMENT_RESOURCES

Line 854: from bom_department_resources bdr

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

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