DBA Data[Home] [Help]

APPS.WIP_INFRESSCHED_GRP dependencies on BOM_DEPARTMENT_RESOURCES

Line 1139: bom_department_resources bdr

1135: from bom_resource_shifts brs,
1136: mtl_parameters mp,
1137: bom_shift_dates bsd,
1138: bom_shift_times bst,
1139: bom_department_resources bdr
1140: where bdr.department_id = v_deptID
1141: and bdr.resource_id = v_resID
1142: and brs.resource_id = bdr.resource_id
1143: and brs.department_id = nvl(bdr.share_from_dept_id,bdr.department_id)

Line 1243: bom_department_resources bdr

1239: into l_dummy
1240: from dual
1241: where exists (select 1
1242: from bom_resource_shifts brs,
1243: bom_department_resources bdr
1244: where bdr.department_id = x_resTbls.deptID(p_idx)
1245: and bdr.resource_id = x_resTbls.resID(p_idx)
1246: and brs.resource_id = bdr.resource_id
1247: and brs.department_id = nvl(bdr.share_from_dept_id,bdr.department_id)

Line 2262: bom_department_resources bdr

2258: from bom_resource_shifts brs,
2259: mtl_parameters mp,
2260: bom_shift_dates bsd,
2261: bom_shift_times bst,
2262: bom_department_resources bdr
2263: where bdr.department_id = v_deptID
2264: and bdr.resource_id = v_resID
2265: and brs.resource_id = bdr.resource_id
2266: and brs.department_id = nvl(bdr.share_from_dept_id,bdr.department_id)

Line 2368: bom_department_resources bdr

2364: into l_dummy
2365: from dual
2366: where exists (select 1
2367: from bom_resource_shifts brs,
2368: bom_department_resources bdr
2369: where bdr.department_id = x_resTbls.deptID(p_idx)
2370: and bdr.resource_id = x_resTbls.resID(p_idx)
2371: and brs.resource_id = bdr.resource_id
2372: and brs.department_id = nvl(bdr.share_from_dept_id,bdr.department_id)