DBA Data[Home] [Help]

APPS.WIP_INFRESSCHED_GRP dependencies on BOM_SHIFT_TIMES

Line 919: bom_shift_times bst,

915: bsd.shift_date + bst.to_time/86400
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

Line 1022: bom_shift_times bst,

1018: where exists (select 1
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

Line 1701: bom_shift_times bst,

1697: bsd.shift_date + bst.to_time/86400
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

Line 1806: bom_shift_times bst,

1802: where exists (select 1
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