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.WIP_REPETITIVE_UTILITIES dependencies on BOM_CALENDAR_DATES

Line 61: FROM BOM_CALENDAR_DATES CD1,

57: CD1.NEXT_SEQ_NUM,
58: CD2.NEXT_SEQ_NUM,
59: CD3.PRIOR_SEQ_NUM,
60: CD4.PRIOR_SEQ_NUM
61: FROM BOM_CALENDAR_DATES CD1,
62: BOM_CALENDAR_DATES CD2,
63: BOM_CALENDAR_DATES CD3,
64: BOM_CALENDAR_DATES CD4,
65: WIP_REPETITIVE_SCHEDULES WRS

Line 62: BOM_CALENDAR_DATES CD2,

58: CD2.NEXT_SEQ_NUM,
59: CD3.PRIOR_SEQ_NUM,
60: CD4.PRIOR_SEQ_NUM
61: FROM BOM_CALENDAR_DATES CD1,
62: BOM_CALENDAR_DATES CD2,
63: BOM_CALENDAR_DATES CD3,
64: BOM_CALENDAR_DATES CD4,
65: WIP_REPETITIVE_SCHEDULES WRS
66: WHERE WRS.ORGANIZATION_ID = p_org_id

Line 63: BOM_CALENDAR_DATES CD3,

59: CD3.PRIOR_SEQ_NUM,
60: CD4.PRIOR_SEQ_NUM
61: FROM BOM_CALENDAR_DATES CD1,
62: BOM_CALENDAR_DATES CD2,
63: BOM_CALENDAR_DATES CD3,
64: BOM_CALENDAR_DATES CD4,
65: WIP_REPETITIVE_SCHEDULES WRS
66: WHERE WRS.ORGANIZATION_ID = p_org_id
67: AND WRS.REPETITIVE_SCHEDULE_ID = p_sched_id

Line 64: BOM_CALENDAR_DATES CD4,

60: CD4.PRIOR_SEQ_NUM
61: FROM BOM_CALENDAR_DATES CD1,
62: BOM_CALENDAR_DATES CD2,
63: BOM_CALENDAR_DATES CD3,
64: BOM_CALENDAR_DATES CD4,
65: WIP_REPETITIVE_SCHEDULES WRS
66: WHERE WRS.ORGANIZATION_ID = p_org_id
67: AND WRS.REPETITIVE_SCHEDULE_ID = p_sched_id
68: AND CD1.CALENDAR_CODE = x_cal_code

Line 236: FROM BOM_CALENDAR_DATES CD1,

232: WRS.ATTRIBUTE8, WRS.ATTRIBUTE9,
233: WRS.ATTRIBUTE10, WRS.ATTRIBUTE11,
234: WRS.ATTRIBUTE12, WRS.ATTRIBUTE13,
235: WRS.ATTRIBUTE14, WRS.ATTRIBUTE15
236: FROM BOM_CALENDAR_DATES CD1,
237: BOM_CALENDAR_DATES CD2,
238: WIP_REPETITIVE_SCHEDULES WRS
239: WHERE WRS.ORGANIZATION_ID = p_org_id
240: AND WRS.REPETITIVE_SCHEDULE_ID = p_sched_id

Line 237: BOM_CALENDAR_DATES CD2,

233: WRS.ATTRIBUTE10, WRS.ATTRIBUTE11,
234: WRS.ATTRIBUTE12, WRS.ATTRIBUTE13,
235: WRS.ATTRIBUTE14, WRS.ATTRIBUTE15
236: FROM BOM_CALENDAR_DATES CD1,
237: BOM_CALENDAR_DATES CD2,
238: WIP_REPETITIVE_SCHEDULES WRS
239: WHERE WRS.ORGANIZATION_ID = p_org_id
240: AND WRS.REPETITIVE_SCHEDULE_ID = p_sched_id
241: AND CD1.CALENDAR_CODE = x_cal_code

Line 266: FROM BOM_CALENDAR_DATES

262: LAST_UNIT_START_DATE =
263: (SELECT TO_DATE(TO_CHAR(CALENDAR_DATE, WIP_CONSTANTS.DATE_FMT) || ' ' ||
264: TO_CHAR(LAST_UNIT_START_DATE, WIP_CONSTANTS.TIMESEC_FMT),
265: WIP_CONSTANTS.DATETIME_FMT)
266: FROM BOM_CALENDAR_DATES
267: WHERE CALENDAR_CODE = x_cal_code
268: AND EXCEPTION_SET_ID = x_excp_set_id
269: AND SEQ_NUM = x_lusd - x_rnd_days_left),
270: LAST_UNIT_COMPLETION_DATE =

Line 275: FROM BOM_CALENDAR_DATES

271: (SELECT TO_DATE(TO_CHAR(CALENDAR_DATE, WIP_CONSTANTS.DATE_FMT) || ' ' ||
272: TO_CHAR(LAST_UNIT_COMPLETION_DATE,
273: WIP_CONSTANTS.TIMESEC_FMT),
274: WIP_CONSTANTS.DATETIME_FMT)
275: FROM BOM_CALENDAR_DATES
276: WHERE CALENDAR_CODE = x_cal_code
277: AND EXCEPTION_SET_ID = x_excp_set_id
278: AND SEQ_NUM = x_lucd - x_rnd_days_left),
279: LAST_UPDATE_DATE = SYSDATE,

Line 355: FROM BOM_CALENDAR_DATES CD1,

351: OPS.ATTRIBUTE8, OPS.ATTRIBUTE9,
352: OPS.ATTRIBUTE10, OPS.ATTRIBUTE11,
353: OPS.ATTRIBUTE12, OPS.ATTRIBUTE13,
354: OPS.ATTRIBUTE14, OPS.ATTRIBUTE15
355: FROM BOM_CALENDAR_DATES CD1,
356: BOM_CALENDAR_DATES CD2,
357: WIP_OPERATIONS OPS
358: WHERE OPS.ORGANIZATION_ID = p_org_id
359: AND OPS.WIP_ENTITY_ID = x_wip_id

Line 356: BOM_CALENDAR_DATES CD2,

352: OPS.ATTRIBUTE10, OPS.ATTRIBUTE11,
353: OPS.ATTRIBUTE12, OPS.ATTRIBUTE13,
354: OPS.ATTRIBUTE14, OPS.ATTRIBUTE15
355: FROM BOM_CALENDAR_DATES CD1,
356: BOM_CALENDAR_DATES CD2,
357: WIP_OPERATIONS OPS
358: WHERE OPS.ORGANIZATION_ID = p_org_id
359: AND OPS.WIP_ENTITY_ID = x_wip_id
360: AND OPS.REPETITIVE_SCHEDULE_ID = p_sched_id

Line 365: FROM BOM_CALENDAR_DATES

361: AND CD1.CALENDAR_CODE = x_cal_code
362: AND CD1.EXCEPTION_SET_ID = x_excp_set_id
363: AND CD1.SEQ_NUM =
364: (SELECT NEXT_SEQ_NUM + x_rnd_days_ran
365: FROM BOM_CALENDAR_DATES
366: WHERE CALENDAR_CODE = x_cal_code
367: AND EXCEPTION_SET_ID = x_excp_set_id
368: AND CALENDAR_DATE =
369: TRUNC(OPS.FIRST_UNIT_START_DATE))

Line 374: FROM BOM_CALENDAR_DATES

370: AND CD2.CALENDAR_CODE = x_cal_code
371: AND CD2.EXCEPTION_SET_ID = x_excp_set_id
372: AND CD2.SEQ_NUM =
373: (SELECT NEXT_SEQ_NUM + x_rnd_days_ran
374: FROM BOM_CALENDAR_DATES
375: WHERE CALENDAR_CODE = x_cal_code
376: AND EXCEPTION_SET_ID = x_excp_set_id
377: AND CALENDAR_DATE =
378: TRUNC(OPS.FIRST_UNIT_COMPLETION_DATE));

Line 395: FROM BOM_CALENDAR_DATES CD1,

391: (SELECT TO_DATE(TO_CHAR(CD2.CALENDAR_DATE, WIP_CONSTANTS.DATE_FMT) || ' ' ||
392: TO_CHAR(OPS.LAST_UNIT_START_DATE,
393: WIP_CONSTANTS.TIMESEC_FMT),
394: WIP_CONSTANTS.DATETIME_FMT)
395: FROM BOM_CALENDAR_DATES CD1,
396: BOM_CALENDAR_DATES CD2
397: WHERE CD1.CALENDAR_CODE = x_cal_code
398: AND CD1.EXCEPTION_SET_ID = x_excp_set_id
399: AND CD1.CALENDAR_DATE =

Line 396: BOM_CALENDAR_DATES CD2

392: TO_CHAR(OPS.LAST_UNIT_START_DATE,
393: WIP_CONSTANTS.TIMESEC_FMT),
394: WIP_CONSTANTS.DATETIME_FMT)
395: FROM BOM_CALENDAR_DATES CD1,
396: BOM_CALENDAR_DATES CD2
397: WHERE CD1.CALENDAR_CODE = x_cal_code
398: AND CD1.EXCEPTION_SET_ID = x_excp_set_id
399: AND CD1.CALENDAR_DATE =
400: TRUNC(OPS.LAST_UNIT_START_DATE)

Line 409: FROM BOM_CALENDAR_DATES CD1,

405: (SELECT TO_DATE(TO_CHAR(CD2.CALENDAR_DATE, WIP_CONSTANTS.DATE_FMT) || ' ' ||
406: TO_CHAR(OPS.LAST_UNIT_COMPLETION_DATE,
407: WIP_CONSTANTS.TIMESEC_FMT),
408: WIP_CONSTANTS.DATETIME_FMT)
409: FROM BOM_CALENDAR_DATES CD1,
410: BOM_CALENDAR_DATES CD2
411: WHERE CD1.CALENDAR_CODE = x_cal_code
412: AND CD1.EXCEPTION_SET_ID = x_excp_set_id
413: AND CD1.CALENDAR_DATE =

Line 410: BOM_CALENDAR_DATES CD2

406: TO_CHAR(OPS.LAST_UNIT_COMPLETION_DATE,
407: WIP_CONSTANTS.TIMESEC_FMT),
408: WIP_CONSTANTS.DATETIME_FMT)
409: FROM BOM_CALENDAR_DATES CD1,
410: BOM_CALENDAR_DATES CD2
411: WHERE CD1.CALENDAR_CODE = x_cal_code
412: AND CD1.EXCEPTION_SET_ID = x_excp_set_id
413: AND CD1.CALENDAR_DATE =
414: TRUNC(OPS.LAST_UNIT_COMPLETION_DATE)

Line 493: FROM BOM_CALENDAR_DATES CD1,

489: (SELECT TO_DATE(TO_CHAR(CD2.CALENDAR_DATE, WIP_CONSTANTS.DATE_FMT) || ' ' ||
490: TO_CHAR(OPS.COMPLETION_DATE,
491: WIP_CONSTANTS.TIMESEC_FMT),
492: WIP_CONSTANTS.DATETIME_FMT)
493: FROM BOM_CALENDAR_DATES CD1,
494: BOM_CALENDAR_DATES CD2
495: WHERE CD1.CALENDAR_CODE = x_cal_code
496: AND CD1.EXCEPTION_SET_ID = x_excp_set_id
497: AND CD1.CALENDAR_DATE =

Line 494: BOM_CALENDAR_DATES CD2

490: TO_CHAR(OPS.COMPLETION_DATE,
491: WIP_CONSTANTS.TIMESEC_FMT),
492: WIP_CONSTANTS.DATETIME_FMT)
493: FROM BOM_CALENDAR_DATES CD1,
494: BOM_CALENDAR_DATES CD2
495: WHERE CD1.CALENDAR_CODE = x_cal_code
496: AND CD1.EXCEPTION_SET_ID = x_excp_set_id
497: AND CD1.CALENDAR_DATE =
498: TRUNC(OPS.COMPLETION_DATE)