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

Line 944: --ugly fnd_columns full table scan twice and we can check for a single entry

940: l_algo_id := FND_OAM_DS_ALGOS_PKG.GET_ALGO_ID(l_algorithm);
941: END IF;
942:
943: --query the application_id, table_id and column_id once so we don't have to do the
944: --ugly fnd_columns full table scan twice and we can check for a single entry
945: SELECT T.application_id, T.table_id, C.column_id, C.column_sequence
946: INTO l_application_id, l_table_id, l_column_id, l_column_seq
947: FROM FND_TABLES T, FND_COLUMNS C
948: WHERE T.TABLE_NAME = upper(l_table_name)

Line 947: FROM FND_TABLES T, FND_COLUMNS C

943: --query the application_id, table_id and column_id once so we don't have to do the
944: --ugly fnd_columns full table scan twice and we can check for a single entry
945: SELECT T.application_id, T.table_id, C.column_id, C.column_sequence
946: INTO l_application_id, l_table_id, l_column_id, l_column_seq
947: FROM FND_TABLES T, FND_COLUMNS C
948: WHERE T.TABLE_NAME = upper(l_table_name)
949: AND T.TABLE_ID = C.TABLE_ID
950: AND C.COLUMN_NAME = upper(l_column_name);
951:

Line 1029: --FIXME: this incurs an unnecessary full table scan of fnd_columns when we should be deleting using the

1025: l_column_name IN VARCHAR2
1026: ) is
1027: begin
1028:
1029: --FIXME: this incurs an unnecessary full table scan of fnd_columns when we should be deleting using the
1030: --known attribute_code, application_id, table_id, column_id to get the index.
1031: delete from FND_COL_PRIV_ATTRIBUTES_B where
1032: PRIVACY_ATTRIBUTE_CODE = attribute_code
1033: and table_id = (select table_id from fnd_tables

Line 1035: and column_id = (select column_id from fnd_columns c, fnd_tables t where

1031: delete from FND_COL_PRIV_ATTRIBUTES_B where
1032: PRIVACY_ATTRIBUTE_CODE = attribute_code
1033: and table_id = (select table_id from fnd_tables
1034: where table_name = upper(l_table_name))
1035: and column_id = (select column_id from fnd_columns c, fnd_tables t where
1036: c.table_id = t.table_id
1037: and t.table_name = upper(l_table_name)
1038: and c.column_name = upper(l_column_name));
1039:

Line 1137: fnd_columns c,

1133: from fnd_oam_ds_policy_elmnts pe,
1134: fnd_privacy_attributes_b pa,
1135: fnd_col_priv_attributes_b pc,
1136: fnd_tables t,
1137: fnd_columns c,
1138: fnd_oam_ds_pii_extensions dpe,
1139: fnd_oam_ds_pii_extensions dpe2,
1140: fnd_product_installations pi,
1141: fnd_oracle_userid ou