DBA Data[Home] [Help]

APPS.AHL_PP_RESRC_ASSIGN_PVT dependencies on BOM_DEPARTMENTS

Line 107: bom_departments bd,

103: SELECT
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

Line 187: bom_departments bd,

183: SELECT
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

Line 289: bom_departments bd,

285: SELECT
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