eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.WIP_INFRESSCHED_GRP dependencies on BOM_CALENDAR_DATES

Line 1164: bom_calendar_dates bcd,

1160: select -1 shiftNum,
1161: bcd.calendar_date + wl.start_time/86400,
1162: bcd.calendar_date + wl.stop_time/86400
1163: from mtl_parameters mp,
1164: bom_calendar_dates bcd,
1165: wip_lines wl
1166: where mp.organization_id = v_orgID
1167: and mp.calendar_code = bcd.calendar_code
1168: and mp.calendar_exception_set_id = bcd.exception_set_id

Line 1181: bom_calendar_dates bcd

1177: select -1,
1178: bcd.calendar_date,
1179: bcd.calendar_date + 1
1180: from mtl_parameters mp,
1181: bom_calendar_dates bcd
1182: where mp.organization_id = v_orgID
1183: and mp.calendar_code = bcd.calendar_code
1184: and mp.calendar_exception_set_id = bcd.exception_set_id
1185: and bcd.calendar_date between v_startDate and v_endDate

Line 2284: bom_calendar_dates bcd

2280: select -1,
2281: bcd.calendar_date,
2282: bcd.calendar_date + 1
2283: from mtl_parameters mp,
2284: bom_calendar_dates bcd
2285: where mp.organization_id = v_orgID
2286: and mp.calendar_code = bcd.calendar_code
2287: and mp.calendar_exception_set_id = bcd.exception_set_id
2288: and bcd.calendar_date between v_startDate and v_endDate

Line 2303: bom_calendar_dates bcd,

2299: select -1 shiftNum,
2300: bcd.calendar_date + wl.start_time/86400,
2301: bcd.calendar_date + wl.stop_time/86400
2302: from mtl_parameters mp,
2303: bom_calendar_dates bcd,
2304: wip_lines wl
2305: where mp.organization_id = v_orgID
2306: and mp.calendar_code = bcd.calendar_code
2307: and mp.calendar_exception_set_id = bcd.exception_set_id