DBA Data[Home] [Help]

APPS.WIP_INFRESSCHED_GRP dependencies on BOM_SHIFT_DATES

Line 918: bom_shift_dates bsd,

914: bsd.shift_date + bst.from_time/86400,
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

Line 1021: bom_shift_dates bsd,

1017: from dual
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)

Line 1700: bom_shift_dates bsd,

1696: bsd.shift_date + bst.from_time/86400,
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

Line 1805: bom_shift_dates bsd,

1801: from dual
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)