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

Line 496: FROM bom_calendar_dates c1,

492: (l_item_attr_rec.repetitive_planned_item = 'N' AND l_item_attr_rec.mbf = 2) THEN
493: IF (l_need_by_date IS NULL) THEN
494: SELECT c1.calendar_date
495: INTO l_need_by_date
496: FROM bom_calendar_dates c1,
497: bom_calendar_dates c
498: WHERE c1.calendar_code = c.calendar_code
499: AND c1.exception_set_id = c.exception_set_id
500: AND c1.seq_num = c.next_seq_num + CEIL(l_item_attr_rec.buying_lead_time)

Line 497: bom_calendar_dates c

493: IF (l_need_by_date IS NULL) THEN
494: SELECT c1.calendar_date
495: INTO l_need_by_date
496: FROM bom_calendar_dates c1,
497: bom_calendar_dates c
498: WHERE c1.calendar_code = c.calendar_code
499: AND c1.exception_set_id = c.exception_set_id
500: AND c1.seq_num = c.next_seq_num + CEIL(l_item_attr_rec.buying_lead_time)
501: AND c.calendar_code = l_cal_code

Line 707: FROM bom_calendar_dates c1,

703: (l_index.reord_qty * nvl(l_item_attr_rec.variable_lead_time,0));
704: BEGIN
705: SELECT c1.calendar_date
706: INTO l_need_by_date
707: FROM bom_calendar_dates c1,
708: bom_calendar_dates c
709: WHERE c1.calendar_code = c.calendar_code
710: AND c1.exception_set_id = c.exception_set_id
711: AND c1.seq_num = (c.next_seq_num + CEIL(l_lead_time))

Line 708: bom_calendar_dates c

704: BEGIN
705: SELECT c1.calendar_date
706: INTO l_need_by_date
707: FROM bom_calendar_dates c1,
708: bom_calendar_dates c
709: WHERE c1.calendar_code = c.calendar_code
710: AND c1.exception_set_id = c.exception_set_id
711: AND c1.seq_num = (c.next_seq_num + CEIL(l_lead_time))
712: AND c.calendar_code = l_cal_code

Line 1016: FROM bom_calendar_dates c1,

1012:
1013: BEGIN
1014: SELECT c1.calendar_date
1015: INTO l_est_date
1016: FROM bom_calendar_dates c1,
1017: bom_calendar_dates c
1018: WHERE c1.calendar_code = c.calendar_code
1019: AND c1.exception_set_id = c.exception_set_id
1020: AND c1.seq_num = c.prior_seq_num - CEIL(l_buying_lt)

Line 1017: bom_calendar_dates c

1013: BEGIN
1014: SELECT c1.calendar_date
1015: INTO l_est_date
1016: FROM bom_calendar_dates c1,
1017: bom_calendar_dates c
1018: WHERE c1.calendar_code = c.calendar_code
1019: AND c1.exception_set_id = c.exception_set_id
1020: AND c1.seq_num = c.prior_seq_num - CEIL(l_buying_lt)
1021: AND c.calendar_code = l_cal_code

Line 1042: FROM bom_calendar_dates c1,

1038: NVL(l_variable_lt,0) * onc.quantity;
1039: BEGIN
1040: SELECT c1.calendar_date
1041: INTO l_est_date
1042: FROM bom_calendar_dates c1,
1043: bom_calendar_dates c
1044: WHERE c1.calendar_code = c.calendar_code
1045: AND c1.exception_set_id = c.exception_set_id
1046: AND c1.seq_num = (c.prior_seq_num - CEIL(l_lead_time))

Line 1043: bom_calendar_dates c

1039: BEGIN
1040: SELECT c1.calendar_date
1041: INTO l_est_date
1042: FROM bom_calendar_dates c1,
1043: bom_calendar_dates c
1044: WHERE c1.calendar_code = c.calendar_code
1045: AND c1.exception_set_id = c.exception_set_id
1046: AND c1.seq_num = (c.prior_seq_num - CEIL(l_lead_time))
1047: AND c.calendar_code = l_cal_code