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.

APPS.MSC_SATP_FUNC dependencies on BOM_CALENDAR_DATES

Line 239: FROM bom_calendar_dates cal,

235: -- the default of daily bucket is used here
236: -- bug 2974334. Change the SQL into static.
237: SELECT cal.prior_date
238: INTO l_return_date
239: FROM bom_calendar_dates cal,
240: mtl_parameters org
241: WHERE cal.calendar_code = org.calendar_code
242: AND cal.exception_set_id = org.calendar_exception_set_id
243: AND cal.calendar_date = TRUNC(p_date)

Line 252: FROM BOM_CALENDAR_DATES cal,

248: IF MSC_CALENDAR.G_RETAIN_DATE = 'Y' THEN
249: BEGIN
250: SELECT min(calendar_date), max(calendar_date)
251: INTO l_first_work_day, l_last_work_day
252: FROM BOM_CALENDAR_DATES cal,
253: mtl_parameters org
254: WHERE cal.calendar_code = org.calendar_code
255: AND cal.exception_set_id = org.calendar_exception_set_id
256: AND org.organization_id = p_organization_id

Line 292: FROM bom_calendar_dates cal,

288:
289: -- bug 2974334. Change the SQL into static.
290: SELECT cal.next_date
291: INTO l_return_date
292: FROM bom_calendar_dates cal,
293: mtl_parameters org
294: WHERE cal.calendar_code = org.calendar_code
295: AND cal.exception_set_id = org.calendar_exception_set_id
296: AND cal.calendar_date = TRUNC(p_date)

Line 306: FROM BOM_CALENDAR_DATES cal,

302: IF MSC_CALENDAR.G_RETAIN_DATE = 'Y' THEN
303: BEGIN
304: SELECT min(calendar_date), max(calendar_date)
305: INTO l_first_work_day, l_last_work_day
306: FROM BOM_CALENDAR_DATES cal,
307: mtl_parameters org
308: WHERE cal.calendar_code = org.calendar_code
309: AND cal.exception_set_id = org.calendar_exception_set_id
310: AND org.organization_id = p_organization_id

Line 356: FROM bom_calendar_dates cal1,

352:
353: -- bug 2974334. Change the SQL into static. Also combined the 2 SQL's into one.
354: SELECT cal2.calendar_date
355: INTO l_return_date
356: FROM bom_calendar_dates cal1,
357: bom_calendar_dates cal2,
358: mtl_parameters org
359: WHERE cal1.calendar_code = org.calendar_code
360: AND cal1.exception_set_id = org.calendar_exception_set_id

Line 357: bom_calendar_dates cal2,

353: -- bug 2974334. Change the SQL into static. Also combined the 2 SQL's into one.
354: SELECT cal2.calendar_date
355: INTO l_return_date
356: FROM bom_calendar_dates cal1,
357: bom_calendar_dates cal2,
358: mtl_parameters org
359: WHERE cal1.calendar_code = org.calendar_code
360: AND cal1.exception_set_id = org.calendar_exception_set_id
361: AND cal1.calendar_date = TRUNC(p_date)

Line 374: FROM BOM_CALENDAR_DATES cal,

370: IF MSC_CALENDAR.G_RETAIN_DATE = 'Y' THEN
371: BEGIN
372: SELECT min(calendar_date), max(calendar_date)
373: INTO l_first_work_day, l_last_work_day
374: FROM BOM_CALENDAR_DATES cal,
375: mtl_parameters org
376: WHERE cal.calendar_code = org.calendar_code
377: AND cal.exception_set_id = org.calendar_exception_set_id
378: AND org.organization_id = p_organization_id

Line 4038: FROM BOM_CALENDAR_DATES

4034: BEGIN
4035:
4036: SELECT NEXT_DATE
4037: INTO l_next_work_day
4038: FROM BOM_CALENDAR_DATES
4039: WHERE CALENDAR_CODE = p_calendar_code
4040: AND EXCEPTION_SET_ID = -1
4041: AND CALENDAR_DATE = TRUNC(p_calendar_date);
4042:

Line 4049: FROM BOM_CALENDAR_DATES

4045: IF MSC_CALENDAR.G_RETAIN_DATE = 'Y' THEN
4046: BEGIN
4047: SELECT min(calendar_date), max(calendar_date)
4048: INTO l_first_work_day, l_last_work_day
4049: FROM BOM_CALENDAR_DATES
4050: WHERE CALENDAR_CODE = p_calendar_code
4051: AND SEQ_NUM is not null;
4052: EXCEPTION
4053: WHEN NO_DATA_FOUND THEN

Line 4096: FROM BOM_CALENDAR_DATES

4092: BEGIN
4093:
4094: SELECT PRIOR_DATE
4095: INTO l_prev_work_day
4096: FROM BOM_CALENDAR_DATES
4097: WHERE CALENDAR_CODE = p_calendar_code
4098: AND EXCEPTION_SET_ID = -1
4099: AND CALENDAR_DATE = TRUNC(p_calendar_date);
4100:

Line 4107: FROM BOM_CALENDAR_DATES

4103: IF MSC_CALENDAR.G_RETAIN_DATE = 'Y' THEN
4104: BEGIN
4105: SELECT min(calendar_date), max(calendar_date)
4106: INTO l_first_work_day, l_last_work_day
4107: FROM BOM_CALENDAR_DATES
4108: WHERE CALENDAR_CODE = p_calendar_code
4109: AND SEQ_NUM is not null;
4110: EXCEPTION
4111: WHEN NO_DATA_FOUND THEN

Line 4176: FROM BOM_CALENDAR_DATES cal1, BOM_CALENDAR_DATES cal2

4172: IF p_days_offset > 0 THEN
4173: BEGIN
4174: SELECT cal2.calendar_date
4175: INTO l_offsetted_day
4176: FROM BOM_CALENDAR_DATES cal1, BOM_CALENDAR_DATES cal2
4177: WHERE cal1.calendar_code = p_calendar_code
4178: AND cal1.exception_set_id = -1
4179: AND cal1.calendar_date = TRUNC(p_calendar_date)
4180: AND cal2.calendar_code = cal1.calendar_code

Line 4191: FROM BOM_CALENDAR_DATES

4187: IF MSC_CALENDAR.G_RETAIN_DATE = 'Y' THEN
4188: BEGIN
4189: SELECT min(calendar_date), max(calendar_date)
4190: INTO l_first_work_day, l_last_work_day
4191: FROM BOM_CALENDAR_DATES
4192: WHERE CALENDAR_CODE = p_calendar_code
4193: AND SEQ_NUM is not null;
4194: EXCEPTION
4195: WHEN NO_DATA_FOUND THEN

Line 4215: FROM BOM_CALENDAR_DATES cal1, BOM_CALENDAR_DATES cal2

4211: ELSE
4212: BEGIN
4213: SELECT cal2.calendar_date
4214: INTO l_offsetted_day
4215: FROM BOM_CALENDAR_DATES cal1, BOM_CALENDAR_DATES cal2
4216: WHERE cal1.calendar_code = p_calendar_code
4217: AND cal1.exception_set_id = -1
4218: AND cal1.calendar_date = TRUNC(p_calendar_date)
4219: AND cal2.calendar_code = cal1.calendar_code

Line 4230: FROM BOM_CALENDAR_DATES

4226: IF MSC_CALENDAR.G_RETAIN_DATE = 'Y' THEN
4227: BEGIN
4228: SELECT min(calendar_date), max(calendar_date)
4229: INTO l_first_work_day, l_last_work_day
4230: FROM BOM_CALENDAR_DATES
4231: WHERE CALENDAR_CODE = p_calendar_code
4232: AND SEQ_NUM is not null;
4233: EXCEPTION
4234: WHEN NO_DATA_FOUND THEN