DBA Data[Home] [Help]

APPS.WIP_INFRESSCHED_GRP dependencies on BOM_DEPARTMENT_RESOURCES

Line 920: bom_department_resources bdr

916: from bom_resource_shifts brs,
917: mtl_parameters mp,
918: bom_shift_dates bsd,
919: bom_shift_times bst,
920: bom_department_resources bdr
921: where bdr.department_id = v_deptID
922: and bdr.resource_id = v_resID
923: and brs.resource_id = bdr.resource_id
924: and brs.department_id = nvl(bdr.share_from_dept_id,bdr.department_id)

Line 1023: bom_department_resources bdr

1019: from bom_resource_shifts brs,
1020: mtl_parameters mp,
1021: bom_shift_dates bsd,
1022: bom_shift_times bst,
1023: bom_department_resources bdr
1024: where bdr.department_id = x_resTbls.deptID(p_idx)
1025: and bdr.resource_id = x_resTbls.resID(p_idx)
1026: and brs.resource_id = bdr.resource_id
1027: and brs.department_id = nvl(bdr.share_from_dept_id,bdr.department_id)

Line 1702: bom_department_resources bdr

1698: from bom_resource_shifts brs,
1699: mtl_parameters mp,
1700: bom_shift_dates bsd,
1701: bom_shift_times bst,
1702: bom_department_resources bdr
1703: where bdr.department_id = v_deptID
1704: and bdr.resource_id = v_resID
1705: and brs.resource_id = bdr.resource_id
1706: and brs.department_id = nvl(bdr.share_from_dept_id,bdr.department_id)

Line 1807: bom_department_resources bdr

1803: from bom_resource_shifts brs,
1804: mtl_parameters mp,
1805: bom_shift_dates bsd,
1806: bom_shift_times bst,
1807: bom_department_resources bdr
1808: where bdr.department_id = x_resTbls.deptID(p_idx)
1809: and bdr.resource_id = x_resTbls.resID(p_idx)
1810: and brs.resource_id = bdr.resource_id
1811: and brs.department_id = nvl(bdr.share_from_dept_id,bdr.department_id)