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.BSC_UPDATE_UTIL dependencies on BSC_DB_CALENDAR

Line 2747: ' FROM bsc_db_calendar'||

2743: -- BSC periodicity
2744: h_calendar_col_name := Get_Calendar_Table_Col_Name(x_periodicity);
2745:
2746: h_sql := 'SELECT MAX('||h_calendar_col_name||')'||
2747: ' FROM bsc_db_calendar'||
2748: ' WHERE year = :1 AND calendar_id = :2';
2749:
2750: OPEN h_cursor FOR h_sql USING x_current_fy, h_calendar_id;
2751: FETCH h_cursor INTO h_num_periods;

Line 2869: ' FROM bsc_db_calendar'||

2865: h_source_col_name := BSC_UPDATE_UTIL.Get_Calendar_Table_Col_Name(p_source_periodicity_id);
2866: h_col_name := BSC_UPDATE_UTIL.Get_Calendar_Table_Col_Name(p_periodicity_id);
2867:
2868: h_sql := 'SELECT DISTINCT '||h_col_name||
2869: ' FROM bsc_db_calendar'||
2870: ' WHERE calendar_id = :1 AND year = :2'||
2871: ' AND '||h_source_col_name||' = :3';
2872: OPEN h_cursor FOR h_sql USING p_calendar_id, p_current_fy, p_source_period;
2873: FETCH h_cursor INTO h_period;

Line 3387: -- Drop Indexes from calendar tables: BSC_DB_CALENDAR, BSC_DB_WEEK_MAPS,

3383: h_count NUMBER;
3384:
3385: BEGIN
3386: -- x_action = 1 || x_action = NULL
3387: -- Drop Indexes from calendar tables: BSC_DB_CALENDAR, BSC_DB_WEEK_MAPS,
3388: -- BSC_SYS_PERIODS_TL to improve performance
3389: -- Note: Indexes on BSC_DB_CALENDAR and BSC_DB_WEEK_MAPS tables were removed.
3390:
3391: --LOCKING: We are not going to drop indexes anymore. If we remove indexes

Line 3389: -- Note: Indexes on BSC_DB_CALENDAR and BSC_DB_WEEK_MAPS tables were removed.

3385: BEGIN
3386: -- x_action = 1 || x_action = NULL
3387: -- Drop Indexes from calendar tables: BSC_DB_CALENDAR, BSC_DB_WEEK_MAPS,
3388: -- BSC_SYS_PERIODS_TL to improve performance
3389: -- Note: Indexes on BSC_DB_CALENDAR and BSC_DB_WEEK_MAPS tables were removed.
3390:
3391: --LOCKING: We are not going to drop indexes anymore. If we remove indexes
3392: -- we cannot load different calendars at the same time
3393: --IF NVL(x_action, 1) = 1 THEN

Line 3426: -- Populate BSC_DB_CALENDAR

3422: h_start_day) THEN
3423: RAISE e_unexpected_error;
3424: END IF;
3425:
3426: -- Populate BSC_DB_CALENDAR
3427: -- It insert row for predefined periodicities
3428: IF NOT Populate_Bsc_Db_Calendar(x_calendar_id,
3429: h_current_fy,
3430: h_start_year,

Line 3428: IF NOT Populate_Bsc_Db_Calendar(x_calendar_id,

3424: END IF;
3425:
3426: -- Populate BSC_DB_CALENDAR
3427: -- It insert row for predefined periodicities
3428: IF NOT Populate_Bsc_Db_Calendar(x_calendar_id,
3429: h_current_fy,
3430: h_start_year,
3431: h_start_month,
3432: h_start_day) THEN

Line 3446: -- in BSC_DB_CALENDAR table

3442: -- fiscal year (i.e in year change process)
3443: -- then it look for the latest year which have records in
3444: -- BSC_SYS_PERIODS.
3445: -- After that it updates the corresponding column
3446: -- in BSC_DB_CALENDAR table
3447:
3448: -- Fix bug#4063282: Need to process custom periodicities in order.
3449: -- First the source, then the target periodicity
3450:

Line 4061: | FUNCTION Populate_Bsc_Db_Calendar

4057: END Make_Lst_Table_Column;
4058:
4059:
4060: /*===========================================================================+
4061: | FUNCTION Populate_Bsc_Db_Calendar
4062: +============================================================================*/
4063: FUNCTION Populate_Bsc_Db_Calendar(
4064: x_calendar_id NUMBER,
4065: X_Current_Fiscal_Yr NUMBER,

Line 4063: FUNCTION Populate_Bsc_Db_Calendar(

4059:
4060: /*===========================================================================+
4061: | FUNCTION Populate_Bsc_Db_Calendar
4062: +============================================================================*/
4063: FUNCTION Populate_Bsc_Db_Calendar(
4064: x_calendar_id NUMBER,
4065: X_Current_Fiscal_Yr NUMBER,
4066: X_Fy_Start_Yr NUMBER,
4067: X_Fy_Start_Mth NUMBER,

Line 4143: -- Delete all rows from bsc_db_calendar

4139: h_first_year := X_Fy_Start_Yr - num_backyears;
4140: h_year_save := X_Current_Fiscal_Yr - num_backyears;
4141: h_last_year := h_first_year + (num_backyears + num_foryears) - 1;
4142:
4143: -- Delete all rows from bsc_db_calendar
4144: /*
4145: sql_stmt := 'DELETE FROM bsc_db_calendar WHERE calendar_id = :1';
4146: EXECUTE IMMEDIATE sql_stmt USING x_calendar_id;
4147: */

Line 4145: sql_stmt := 'DELETE FROM bsc_db_calendar WHERE calendar_id = :1';

4141: h_last_year := h_first_year + (num_backyears + num_foryears) - 1;
4142:
4143: -- Delete all rows from bsc_db_calendar
4144: /*
4145: sql_stmt := 'DELETE FROM bsc_db_calendar WHERE calendar_id = :1';
4146: EXECUTE IMMEDIATE sql_stmt USING x_calendar_id;
4147: */
4148: DELETE FROM bsc_db_calendar WHERE calendar_id = x_calendar_id;
4149:

Line 4148: DELETE FROM bsc_db_calendar WHERE calendar_id = x_calendar_id;

4144: /*
4145: sql_stmt := 'DELETE FROM bsc_db_calendar WHERE calendar_id = :1';
4146: EXECUTE IMMEDIATE sql_stmt USING x_calendar_id;
4147: */
4148: DELETE FROM bsc_db_calendar WHERE calendar_id = x_calendar_id;
4149:
4150: h_pername_list := 'year, semester, quarter, bimester, month, week52, '||
4151: 'week4, day365, day30';
4152:

Line 4178: 'INSERT INTO bsc_db_calendar (calendar_id, calendar_year, calendar_month,'||

4174: h_year := to_number(to_char(h_current_date, 'YYYY'));
4175:
4176: /*
4177: sql_stmt :=
4178: 'INSERT INTO bsc_db_calendar (calendar_id, calendar_year, calendar_month,'||
4179: ' calendar_day, ' || h_pername_list ||
4180: ') VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)';
4181:
4182: h_bind_vars_values.delete;

Line 4200: INSERT INTO bsc_db_calendar (calendar_id, calendar_year, calendar_month, calendar_day,

4196: h_num_bind_vars := 13;
4197: BSC_UPDATE_UTIL.Execute_Immediate(sql_stmt, h_bind_vars_values, h_num_bind_vars);
4198: */
4199:
4200: INSERT INTO bsc_db_calendar (calendar_id, calendar_year, calendar_month, calendar_day,
4201: year, semester, quarter, bimester, month, week52, week4, day365, day30)
4202: VALUES (x_calendar_id, h_year, h_month, h_day, h_year_save, h_semester, h_quarterly,
4203: h_bimonthly, h_monthly, h_weekly52, h_weekly4, h_daily365, h_daily30);
4204:

Line 4250: X_Source => 'BSC_UPDATE_UTIL.Populate_Bsc_Db_Calendar');

4246: EXCEPTION
4247: WHEN OTHERS THEN
4248: BSC_MESSAGE.Add(
4249: X_Message => SQLERRM,
4250: X_Source => 'BSC_UPDATE_UTIL.Populate_Bsc_Db_Calendar');
4251: RETURN FALSE;
4252:
4253: END Populate_Bsc_Db_Calendar;
4254:

Line 4253: END Populate_Bsc_Db_Calendar;

4249: X_Message => SQLERRM,
4250: X_Source => 'BSC_UPDATE_UTIL.Populate_Bsc_Db_Calendar');
4251: RETURN FALSE;
4252:
4253: END Populate_Bsc_Db_Calendar;
4254:
4255:
4256: /*===========================================================================+
4257: | FUNCTION Populate_Bsc_Db_Week_Maps

Line 4278: ' FROM bsc_db_calendar'||

4274:
4275: -- Insert the records
4276: /* sql_stmt := 'INSERT INTO bsc_db_week_maps (year, month, week, week52, calendar_id)'||
4277: ' SELECT year, min(month), week4, week52, calendar_id'||
4278: ' FROM bsc_db_calendar'||
4279: ' WHERE calendar_id = :1'||
4280: ' GROUP BY year, week4, week52, calendar_id';
4281: EXECUTE IMMEDIATE sql_stmt USING x_calendar_id; */
4282: INSERT INTO bsc_db_week_maps (year, month, week, week52, calendar_id)

Line 4284: FROM bsc_db_calendar

4280: ' GROUP BY year, week4, week52, calendar_id';
4281: EXECUTE IMMEDIATE sql_stmt USING x_calendar_id; */
4282: INSERT INTO bsc_db_week_maps (year, month, week, week52, calendar_id)
4283: SELECT year, min(month), week4, week52, calendar_id
4284: FROM bsc_db_calendar
4285: WHERE calendar_id = x_calendar_id
4286: GROUP BY year, week4, week52, calendar_id;
4287:
4288: RETURN TRUE;

Line 4352: BSC_DB_CALENDAR C,

4348: P.PERIODICITY_ID AS PERIODICITY_ID,
4349: C.SEMESTER AS PERIOD_ID,
4350: C.CALENDAR_MONTH||';'||C2.CALENDAR_MONTH AS NAME
4351: FROM
4352: BSC_DB_CALENDAR C,
4353: BSC_DB_CALENDAR C2,
4354: BSC_SYS_PERIODICITIES P
4355: WHERE
4356: P.CALENDAR_ID = x_calendar_id AND

Line 4353: BSC_DB_CALENDAR C2,

4349: C.SEMESTER AS PERIOD_ID,
4350: C.CALENDAR_MONTH||';'||C2.CALENDAR_MONTH AS NAME
4351: FROM
4352: BSC_DB_CALENDAR C,
4353: BSC_DB_CALENDAR C2,
4354: BSC_SYS_PERIODICITIES P
4355: WHERE
4356: P.CALENDAR_ID = x_calendar_id AND
4357: P.PERIODICITY_TYPE = 2 AND

Line 4364: FROM BSC_DB_CALENDAR C1

4360: C.CALENDAR_ID = P.CALENDAR_ID AND
4361: C.SEMESTER = C2.SEMESTER AND
4362: TO_DATE(C.CALENDAR_YEAR||'-'||C.CALENDAR_MONTH||'-'||C.CALENDAR_DAY,'YYYY-MM-DD') =
4363: (SELECT MIN(TO_DATE(C1.CALENDAR_YEAR||'-'||C1.CALENDAR_MONTH||'-'||C1.CALENDAR_DAY,'YYYY-MM-DD'))
4364: FROM BSC_DB_CALENDAR C1
4365: WHERE C1.YEAR = C.YEAR AND C1.SEMESTER = C.SEMESTER AND C1.CALENDAR_ID = C.CALENDAR_ID
4366: ) AND
4367: TO_DATE(C2.CALENDAR_YEAR||'-'||C2.CALENDAR_MONTH||'-'||C2.CALENDAR_DAY,'YYYY-MM-DD') =
4368: (SELECT MAX(TO_DATE(C1.CALENDAR_YEAR||'-'||C1.CALENDAR_MONTH||'-'||C1.CALENDAR_DAY,'YYYY-MM-DD'))

Line 4369: FROM BSC_DB_CALENDAR C1

4365: WHERE C1.YEAR = C.YEAR AND C1.SEMESTER = C.SEMESTER AND C1.CALENDAR_ID = C.CALENDAR_ID
4366: ) AND
4367: TO_DATE(C2.CALENDAR_YEAR||'-'||C2.CALENDAR_MONTH||'-'||C2.CALENDAR_DAY,'YYYY-MM-DD') =
4368: (SELECT MAX(TO_DATE(C1.CALENDAR_YEAR||'-'||C1.CALENDAR_MONTH||'-'||C1.CALENDAR_DAY,'YYYY-MM-DD'))
4369: FROM BSC_DB_CALENDAR C1
4370: WHERE C1.YEAR = C2.YEAR AND C1.SEMESTER = C2.SEMESTER AND C1.CALENDAR_ID = C2.CALENDAR_ID
4371: )
4372: UNION
4373: SELECT

Line 4379: BSC_DB_CALENDAR C,

4375: P.PERIODICITY_ID AS PERIODICITY_ID,
4376: C.QUARTER AS PERIOD_ID,
4377: C.CALENDAR_MONTH||';'||C2.CALENDAR_MONTH AS NAME
4378: FROM
4379: BSC_DB_CALENDAR C,
4380: BSC_DB_CALENDAR C2,
4381: BSC_SYS_PERIODICITIES P
4382: WHERE
4383: P.CALENDAR_ID = x_calendar_id AND

Line 4380: BSC_DB_CALENDAR C2,

4376: C.QUARTER AS PERIOD_ID,
4377: C.CALENDAR_MONTH||';'||C2.CALENDAR_MONTH AS NAME
4378: FROM
4379: BSC_DB_CALENDAR C,
4380: BSC_DB_CALENDAR C2,
4381: BSC_SYS_PERIODICITIES P
4382: WHERE
4383: P.CALENDAR_ID = x_calendar_id AND
4384: P.PERIODICITY_TYPE = 3 AND

Line 4391: FROM BSC_DB_CALENDAR C1

4387: C.CALENDAR_ID = P.CALENDAR_ID AND
4388: C.QUARTER = C2.QUARTER AND
4389: TO_DATE(C.CALENDAR_YEAR||'-'||C.CALENDAR_MONTH||'-'||C.CALENDAR_DAY,'YYYY-MM-DD') =
4390: (SELECT MIN(TO_DATE(C1.CALENDAR_YEAR||'-'||C1.CALENDAR_MONTH||'-'||C1.CALENDAR_DAY,'YYYY-MM-DD'))
4391: FROM BSC_DB_CALENDAR C1
4392: WHERE C1.YEAR = C.YEAR AND C1.QUARTER = C.QUARTER AND C1.CALENDAR_ID = C.CALENDAR_ID
4393: ) AND
4394: TO_DATE(C2.CALENDAR_YEAR||'-'||C2.CALENDAR_MONTH||'-'||C2.CALENDAR_DAY,'YYYY-MM-DD') =
4395: (SELECT MAX(TO_DATE(C1.CALENDAR_YEAR||'-'||C1.CALENDAR_MONTH||'-'||C1.CALENDAR_DAY,'YYYY-MM-DD'))

Line 4396: FROM BSC_DB_CALENDAR C1

4392: WHERE C1.YEAR = C.YEAR AND C1.QUARTER = C.QUARTER AND C1.CALENDAR_ID = C.CALENDAR_ID
4393: ) AND
4394: TO_DATE(C2.CALENDAR_YEAR||'-'||C2.CALENDAR_MONTH||'-'||C2.CALENDAR_DAY,'YYYY-MM-DD') =
4395: (SELECT MAX(TO_DATE(C1.CALENDAR_YEAR||'-'||C1.CALENDAR_MONTH||'-'||C1.CALENDAR_DAY,'YYYY-MM-DD'))
4396: FROM BSC_DB_CALENDAR C1
4397: WHERE C1.YEAR = C2.YEAR AND C1.QUARTER = C2.QUARTER AND C1.CALENDAR_ID = C2.CALENDAR_ID
4398: )
4399: UNION
4400: SELECT

Line 4406: BSC_DB_CALENDAR C,

4402: P.PERIODICITY_ID AS PERIODICITY_ID,
4403: C.BIMESTER AS PERIOD_ID,
4404: C.CALENDAR_MONTH||';'||C2.CALENDAR_MONTH AS NAME
4405: FROM
4406: BSC_DB_CALENDAR C,
4407: BSC_DB_CALENDAR C2,
4408: BSC_SYS_PERIODICITIES P
4409: WHERE
4410: P.CALENDAR_ID = x_calendar_id AND

Line 4407: BSC_DB_CALENDAR C2,

4403: C.BIMESTER AS PERIOD_ID,
4404: C.CALENDAR_MONTH||';'||C2.CALENDAR_MONTH AS NAME
4405: FROM
4406: BSC_DB_CALENDAR C,
4407: BSC_DB_CALENDAR C2,
4408: BSC_SYS_PERIODICITIES P
4409: WHERE
4410: P.CALENDAR_ID = x_calendar_id AND
4411: P.PERIODICITY_TYPE = 4 AND

Line 4418: FROM BSC_DB_CALENDAR C1

4414: C.CALENDAR_ID = P.CALENDAR_ID AND
4415: C.BIMESTER = C2.BIMESTER AND
4416: TO_DATE(C.CALENDAR_YEAR||'-'||C.CALENDAR_MONTH||'-'||C.CALENDAR_DAY,'YYYY-MM-DD') =
4417: (SELECT MIN(TO_DATE(C1.CALENDAR_YEAR||'-'||C1.CALENDAR_MONTH||'-'||C1.CALENDAR_DAY,'YYYY-MM-DD'))
4418: FROM BSC_DB_CALENDAR C1
4419: WHERE C1.YEAR = C.YEAR AND C1.BIMESTER = C.BIMESTER AND C1.CALENDAR_ID = C.CALENDAR_ID
4420: ) AND
4421: TO_DATE(C2.CALENDAR_YEAR||'-'||C2.CALENDAR_MONTH||'-'||C2.CALENDAR_DAY,'YYYY-MM-DD') =
4422: (SELECT MAX(TO_DATE(C1.CALENDAR_YEAR||'-'||C1.CALENDAR_MONTH||'-'||C1.CALENDAR_DAY,'YYYY-MM-DD'))

Line 4423: FROM BSC_DB_CALENDAR C1

4419: WHERE C1.YEAR = C.YEAR AND C1.BIMESTER = C.BIMESTER AND C1.CALENDAR_ID = C.CALENDAR_ID
4420: ) AND
4421: TO_DATE(C2.CALENDAR_YEAR||'-'||C2.CALENDAR_MONTH||'-'||C2.CALENDAR_DAY,'YYYY-MM-DD') =
4422: (SELECT MAX(TO_DATE(C1.CALENDAR_YEAR||'-'||C1.CALENDAR_MONTH||'-'||C1.CALENDAR_DAY,'YYYY-MM-DD'))
4423: FROM BSC_DB_CALENDAR C1
4424: WHERE C1.YEAR = C2.YEAR AND C1.BIMESTER = C2.BIMESTER AND C1.CALENDAR_ID = C2.CALENDAR_ID
4425: )
4426: UNION
4427: SELECT

Line 4433: BSC_DB_CALENDAR C,

4429: P.PERIODICITY_ID AS PERIODICITY_ID,
4430: C.MONTH AS PERIOD_ID,
4431: TO_CHAR(C.CALENDAR_MONTH) AS NAME
4432: FROM
4433: BSC_DB_CALENDAR C,
4434: BSC_SYS_PERIODICITIES P
4435: WHERE
4436: P.CALENDAR_ID = x_calendar_id AND
4437: P.PERIODICITY_TYPE = 5 AND

Line 4447: BSC_DB_CALENDAR C,

4443: P.PERIODICITY_ID AS PERIODICITY_ID,
4444: C.WEEK52 AS PERIOD_ID,
4445: C.CALENDAR_MONTH||';'||C.CALENDAR_DAY AS NAME
4446: FROM
4447: BSC_DB_CALENDAR C,
4448: BSC_SYS_PERIODICITIES P
4449: WHERE
4450: P.CALENDAR_ID = x_calendar_id AND
4451: C.CALENDAR_ID = P.CALENDAR_ID AND

Line 4455: FROM BSC_DB_CALENDAR C1

4451: C.CALENDAR_ID = P.CALENDAR_ID AND
4452: P.PERIODICITY_TYPE = 7 AND
4453: TO_DATE(C.CALENDAR_YEAR||'-'||C.CALENDAR_MONTH||'-'||C.CALENDAR_DAY,'YYYY-MM-DD') =
4454: (SELECT MAX(TO_DATE(C1.CALENDAR_YEAR||'-'||C1.CALENDAR_MONTH||'-'||C1.CALENDAR_DAY,'YYYY-MM-DD'))
4455: FROM BSC_DB_CALENDAR C1
4456: WHERE C1.YEAR = C.YEAR AND C1.WEEK52 = C.WEEK52 AND C1.CALENDAR_ID = C.CALENDAR_ID
4457: )
4458: UNION
4459: SELECT

Line 4465: BSC_DB_CALENDAR C,

4461: P.PERIODICITY_ID AS PERIODICITY_ID,
4462: C.DAY365 AS PERIOD_ID,
4463: C.CALENDAR_MONTH||';'||C.CALENDAR_DAY AS NAME
4464: FROM
4465: BSC_DB_CALENDAR C,
4466: BSC_SYS_PERIODICITIES P
4467: WHERE
4468: P.CALENDAR_ID = x_calendar_id AND
4469: P.PERIODICITY_TYPE = 9 AND

Line 4497: BSC_DB_CALENDAR C,

4493: L.LANGUAGE_CODE AS SOURCE_LANG,
4494: C.CALENDAR_MONTH||'';''||C.CALENDAR_DAY AS NAME,
4495: NULL AS SHORT_NAME
4496: FROM
4497: BSC_DB_CALENDAR C,
4498: FND_LANGUAGES L
4499: WHERE
4500: L.INSTALLED_FLAG <> ''D'' AND
4501: C.CALENDAR_ID = :2 AND

Line 4506: BSC_DB_CALENDAR C1

4502: TO_DATE(C.CALENDAR_YEAR||''-''||C.CALENDAR_MONTH||''-''||C.CALENDAR_DAY,''YYYY-MM-DD'') =
4503: (SELECT
4504: MAX(TO_DATE(C1.CALENDAR_YEAR||''-''||C1.CALENDAR_MONTH||''-''||C1.CALENDAR_DAY,''YYYY-MM-DD''))
4505: FROM
4506: BSC_DB_CALENDAR C1
4507: WHERE
4508: C1.YEAR = C.YEAR AND
4509: C1.'||h_db_column_name||' = C.'||h_db_column_name||' AND
4510: C1.CALENDAR_ID = C.CALENDAR_ID

Line 5462: FROM bsc_db_calendar c, bsc_sys_periods p

5458: h_cursor t_cursor;
5459:
5460: CURSOR c_missing_years (p_calendar_id NUMBER, p_periodicity_id NUMBER) IS
5461: SELECT DISTINCT c.year
5462: FROM bsc_db_calendar c, bsc_sys_periods p
5463: WHERE c.calendar_id = p_calendar_id AND p_periodicity_id = p.periodicity_id (+) AND
5464: c.year = p.year (+) AND p.year IS NULL;
5465:
5466: h_year NUMBER;

Line 5850: -- Update the corresponding column in BSC_DB_CALENDAR for this periodicity

5846: FETCH c_missing_years INTO h_year;
5847: END LOOP;
5848: CLOSE c_missing_years;
5849:
5850: -- Update the corresponding column in BSC_DB_CALENDAR for this periodicity
5851: h_db_column_name := Get_Calendar_Table_Col_Name(x_periodicity_id);
5852:
5853: IF x_custom_code = 1 THEN
5854: -- Based on range of dates --> Use start_date and end_date

Line 5856: bsc_db_calendar d

5852:
5853: IF x_custom_code = 1 THEN
5854: -- Based on range of dates --> Use start_date and end_date
5855: h_sql := 'UPDATE
5856: bsc_db_calendar d
5857: SET '||h_db_column_name||' = (
5858: SELECT
5859: p.period_id
5860: FROM

Line 5888: bsc_db_calendar d

5884: IF h_source_periodicity IS NOT NULL THEN
5885: h_db_source_column_name := Get_Calendar_Table_Col_Name(h_source_periodicity);
5886:
5887: h_sql := 'UPDATE
5888: bsc_db_calendar d
5889: SET '||h_db_column_name||' = (
5890: SELECT
5891: p.period_id
5892: FROM