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: WHERE
191: bdr.resource_id = p_resource_id and
192: bdr.department_id = bd.department_id and

Line 288: bom_department_resources bdr

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

Line 1121: bom_department_resources bdr

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

Line 2089: bom_department_resources bdr

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