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.ITA_RECORD_CURR_STATUS_PKG dependencies on FND_COLUMNS

Line 253: from FND_COLUMNS fc

249: SETUP_GROUP_CODE,
250: COLUMN_ID,
251: (
252: select COLUMN_NAME
253: from FND_COLUMNS fc
254: where
255: (APPLICATION_ID, TABLE_ID) = (
256: select TABLE_APP_ID, TABLE_ID
257: from ITA_SETUP_GROUPS_B

Line 376: l_column_name FND_COLUMNS.COLUMN_NAME%TYPE;

372: l_select_clause ITA_SETUP_PARAMETERS_B.SELECT_CLAUSE%TYPE;
373: l_from_clause ITA_SETUP_PARAMETERS_B.FROM_CLAUSE%TYPE;
374: l_where_clause ITA_SETUP_PARAMETERS_B.WHERE_CLAUSE%TYPE;
375: l_ins_sql VARCHAR2(32767);
376: l_column_name FND_COLUMNS.COLUMN_NAME%TYPE;
377: l_user_id NUMBER;
378: l_login_id NUMBER;
379: l_inst_code ITA_SETUP_CHANGE_HISTORY.INSTANCE_CODE%TYPE;
380: l_rec_val_code_sql VARCHAR2(32767);

Line 385: from fnd_columns fnd, ita_setup_parameters_b isp

381:
382: CURSOR c_get_parameters(p_setup_group_code IN VARCHAR2)
383: IS
384: SELECT fnd.column_name, isp.parameter_code
385: from fnd_columns fnd, ita_setup_parameters_b isp
386: WHERE isp.setup_group_code = p_setup_group_code AND
387: isp.column_id = fnd.column_id;
388:
389: l_param_rec c_get_parameters%ROWTYPE;

Line 420: from FND_COLUMNS

416: setup_gp.TABLE_ID = l_table_id;
417:
418: select COLUMN_NAME
419: INTO l_column_name
420: from FND_COLUMNS
421: where (APPLICATION_ID, TABLE_ID) = (select TABLE_APP_ID, TABLE_ID
422: from ITA_SETUP_GROUPS_B
423: where SETUP_GROUP_CODE = l_setup_gp_code) and
424: COLUMN_ID = l_column_id;

Line 627: l_column_name FND_COLUMNS.COLUMN_NAME%TYPE;

623: l_del_sql VARCHAR2(32767);
624: l_select_clause ITA_SETUP_PARAMETERS_B.SELECT_CLAUSE%TYPE;
625: l_ins_sql VARCHAR2(32767);
626: l_ins_param_sql VARCHAR2(32767);
627: l_column_name FND_COLUMNS.COLUMN_NAME%TYPE;
628: l_column_name1 FND_COLUMNS.COLUMN_NAME%TYPE;
629: l_user_id NUMBER;
630: l_login_id NUMBER;
631: l_inst_code ITA_SETUP_CHANGE_HISTORY.INSTANCE_CODE%TYPE;

Line 628: l_column_name1 FND_COLUMNS.COLUMN_NAME%TYPE;

624: l_select_clause ITA_SETUP_PARAMETERS_B.SELECT_CLAUSE%TYPE;
625: l_ins_sql VARCHAR2(32767);
626: l_ins_param_sql VARCHAR2(32767);
627: l_column_name FND_COLUMNS.COLUMN_NAME%TYPE;
628: l_column_name1 FND_COLUMNS.COLUMN_NAME%TYPE;
629: l_user_id NUMBER;
630: l_login_id NUMBER;
631: l_inst_code ITA_SETUP_CHANGE_HISTORY.INSTANCE_CODE%TYPE;
632: l_rec_val_code_sql VARCHAR2(32767);

Line 690: from FND_COLUMNS

686: setup_gp.TABLE_ID = l_table_id;
687:
688: select COLUMN_NAME
689: INTO l_column_name
690: from FND_COLUMNS
691: where (APPLICATION_ID, TABLE_ID) = (select TABLE_APP_ID, TABLE_ID
692: from ITA_SETUP_GROUPS_B
693: where SETUP_GROUP_CODE = l_setup_gp_code)
694: and COLUMN_ID = l_column_id;

Line 698: from FND_COLUMNS

694: and COLUMN_ID = l_column_id;
695:
696: select COLUMN_NAME
697: INTO l_column_name1
698: from FND_COLUMNS
699: where (APPLICATION_ID, TABLE_ID) = (select TABLE_APP_ID, TABLE_ID
700: from ITA_SETUP_GROUPS_B
701: where SETUP_GROUP_CODE = l_setup_gp_code)
702: and COLUMN_ID = l_column_id1;