APPS.INV_COPY_ORGANIZATION_REPORT dependencies on BOM_DEPARTMENT_RESOURCES

Line 952: Init_Vars('BOM_DEPARTMENT_RESOURCES');

948: Init_Vars('BOM_DEPARTMENTS');
949: g_entity_names := Get_Err_Bom_Departments;
950: Put_Report_Data;
951:
952: Init_Vars('BOM_DEPARTMENT_RESOURCES');
953: g_entity_names := Get_Err_Bom_Dept_Res;
954: Put_Report_Data;
955:
956: Init_Vars('BOM_RESOURCES');

Line 3536: FROM BOM_DEPARTMENT_RESOURCES ent

3532: , p_organization_id NUMBER
3533: )
3534: IS
3535: SELECT bd.DEPARTMENT_CODE, br.RESOURCE_CODE
3536: FROM BOM_DEPARTMENT_RESOURCES ent
3537: , BOM_DEPARTMENTS bd
3538: , BOM_RESOURCES br
3539: WHERE br.RESOURCE_ID = ent.RESOURCE_ID
3540: AND ent.RESOURCE_ID IN ( SELECT br.RESOURCE_ID

Line 3551: FROM BOM_DEPARTMENT_RESOURCES ent

3547: WHERE bd.ORGANIZATION_ID=p_model_org_id
3548: )
3549: MINUS
3550: SELECT bd.DEPARTMENT_CODE, br.RESOURCE_CODE
3551: FROM BOM_DEPARTMENT_RESOURCES ent
3552: , BOM_DEPARTMENTS bd
3553: , BOM_RESOURCES br
3554: WHERE br.RESOURCE_ID = ent.RESOURCE_ID
3555: AND ent.RESOURCE_ID IN ( SELECT br.RESOURCE_ID

Line 3568: FROM BOM_DEPARTMENT_RESOURCES ent

3564:
3565: CURSOR l_cursor_cnt ( p_org_id NUMBER )
3566: IS
3567: SELECT COUNT(ent.RESOURCE_ID)
3568: FROM BOM_DEPARTMENT_RESOURCES ent
3569: WHERE ent.RESOURCE_ID IN
3570: (
3571: SELECT br.RESOURCE_ID
3572: FROM BOM_RESOURCES br