APPS.AHL_PP_RESRC_ASSIGN_PVT dependencies on BOM_DEPARTMENT_RESOURCES

Line 108: bom_department_resources bdr

104: nvl(bdr.SHARE_FROM_DEPT_ID,
105: bdr.department_id)
106: FROM
107: bom_departments bd,
108: bom_department_resources bdr
109: WHERE
110: bdr.resource_id = p_resource_id and
111: bdr.department_id = bd.department_id and
112: bd.organization_id = p_organization_id

Line 188: bom_department_resources bdr

184: nvl(bdr.SHARE_FROM_DEPT_ID,
185: bdr.department_id)
186: FROM
187: bom_departments bd,
188: bom_department_resources bdr
189: --ahl_pp_requirement_v aprv
190: --Removed since The view is not being used.
191: --for bug #9031320
192: WHERE

Line 290: bom_department_resources bdr

286: nvl(bdr.SHARE_FROM_DEPT_ID,
287: bdr.department_id)
288: FROM
289: bom_departments bd,
290: bom_department_resources bdr
291: WHERE
292: bdr.resource_id = p_resource_id and
293: bdr.department_id = bd.department_id and
294: bd.organization_id = p_organization_id

Line 1123: bom_department_resources bdr

1119: SELECT
1120: nvl(bdr.SHARE_FROM_DEPT_ID,
1121: bdr.department_id)
1122: FROM
1123: bom_department_resources bdr
1124: WHERE
1125: bdr.resource_id = c_resource_id and
1126: bdr.department_id = c_dept_id
1127: );

Line 2091: bom_department_resources bdr

2087: SELECT
2088: nvl(bdr.SHARE_FROM_DEPT_ID,
2089: bdr.department_id)
2090: FROM
2091: bom_department_resources bdr
2092: WHERE
2093: bdr.resource_id = c_resource_id and
2094: bdr.department_id = c_dept_id
2095: );