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_STATS dependencies on DBA_TAB_COLUMNS

Line 3633: FROM dba_tab_columns a ,

3629: -- break out if it doesn't exist
3630: BEGIN
3631: SELECT DISTINCT('EXIST')
3632: INTO exist_flag
3633: FROM dba_tab_columns a ,
3634: fnd_oracle_userid b,
3635: fnd_product_installations c
3636: WHERE a.table_name = upper(tabname)
3637: AND a.column_name = upper(colname)

Line 3648: || ' does not exist in dba_tab_columns for the given application ');

3644: raise_application_error(-20000, 'Column '
3645: || tabname
3646: ||'.'
3647: || colname
3648: || ' does not exist in dba_tab_columns for the given application ');
3649: WHEN OTHERS THEN
3650: raise_application_error(-20001, 'Error in reading dictionary info. for column '
3651: || tabname
3652: ||'.'

Line 3732: FROM dba_tab_columns a

3728: -- break out if it doesn't exist
3729: BEGIN
3730: SELECT DISTINCT('EXIST')
3731: INTO exist_flag
3732: FROM dba_tab_columns a
3733: WHERE a.table_name = upper(tabname)
3734: AND a.column_name = upper(colname)
3735: AND a.owner = upper(ownername);
3736:

Line 3743: || ' does not exist in dba_tab_columns for the given owner ');

3739: raise_application_error(-20000, 'Column '
3740: || tabname
3741: ||'.'
3742: || colname
3743: || ' does not exist in dba_tab_columns for the given owner ');
3744: WHEN OTHERS THEN
3745: raise_application_error(-20001, 'Error in reading dictionary info. for column '
3746: || tabname
3747: ||'.'

Line 4453: last_analyzed dba_tab_columns.last_analyzed%type;

4449: IS
4450: found0 BOOLEAN := false;
4451: found1 BOOLEAN := false;
4452: status VARCHAR2(64) := 'not present';
4453: last_analyzed dba_tab_columns.last_analyzed%type;
4454: CURSOR histo_details(schema VARCHAR2, tableName VARCHAR2, columnName VARCHAR2)
4455: IS
4456: SELECT endpoint_number,
4457: last_analyzed

Line 4459: dba_tab_columns b

4455: IS
4456: SELECT endpoint_number,
4457: last_analyzed
4458: FROM dba_histograms a,
4459: dba_tab_columns b
4460: WHERE a.owner = schema
4461: AND a.table_name = tableName
4462: AND a.column_name = columnName
4463: AND a.owner = b.owner

Line 4513: PROCEDURE column_stats(column_name dba_tab_columns.column_name%type,

4509: /* Procedure: column_stats */
4510: /* Desciption: Internal procedures used by verify_stats. Gets info about*/
4511: /* about column stats. */
4512: /************************************************************************/
4513: PROCEDURE column_stats(column_name dba_tab_columns.column_name%type,
4514: num_distinct dba_tab_columns.num_distinct%type,
4515: num_nulls dba_tab_columns.num_nulls%type,
4516: density dba_tab_columns.density%type,
4517: sample_size dba_tab_columns.sample_size%type,

Line 4514: num_distinct dba_tab_columns.num_distinct%type,

4510: /* Desciption: Internal procedures used by verify_stats. Gets info about*/
4511: /* about column stats. */
4512: /************************************************************************/
4513: PROCEDURE column_stats(column_name dba_tab_columns.column_name%type,
4514: num_distinct dba_tab_columns.num_distinct%type,
4515: num_nulls dba_tab_columns.num_nulls%type,
4516: density dba_tab_columns.density%type,
4517: sample_size dba_tab_columns.sample_size%type,
4518: last_analyzed dba_tab_columns.last_analyzed%type,

Line 4515: num_nulls dba_tab_columns.num_nulls%type,

4511: /* about column stats. */
4512: /************************************************************************/
4513: PROCEDURE column_stats(column_name dba_tab_columns.column_name%type,
4514: num_distinct dba_tab_columns.num_distinct%type,
4515: num_nulls dba_tab_columns.num_nulls%type,
4516: density dba_tab_columns.density%type,
4517: sample_size dba_tab_columns.sample_size%type,
4518: last_analyzed dba_tab_columns.last_analyzed%type,
4519: first_col BOOLEAN)

Line 4516: density dba_tab_columns.density%type,

4512: /************************************************************************/
4513: PROCEDURE column_stats(column_name dba_tab_columns.column_name%type,
4514: num_distinct dba_tab_columns.num_distinct%type,
4515: num_nulls dba_tab_columns.num_nulls%type,
4516: density dba_tab_columns.density%type,
4517: sample_size dba_tab_columns.sample_size%type,
4518: last_analyzed dba_tab_columns.last_analyzed%type,
4519: first_col BOOLEAN)
4520: IS

Line 4517: sample_size dba_tab_columns.sample_size%type,

4513: PROCEDURE column_stats(column_name dba_tab_columns.column_name%type,
4514: num_distinct dba_tab_columns.num_distinct%type,
4515: num_nulls dba_tab_columns.num_nulls%type,
4516: density dba_tab_columns.density%type,
4517: sample_size dba_tab_columns.sample_size%type,
4518: last_analyzed dba_tab_columns.last_analyzed%type,
4519: first_col BOOLEAN)
4520: IS
4521: val1 VARCHAR2(255);

Line 4518: last_analyzed dba_tab_columns.last_analyzed%type,

4514: num_distinct dba_tab_columns.num_distinct%type,
4515: num_nulls dba_tab_columns.num_nulls%type,
4516: density dba_tab_columns.density%type,
4517: sample_size dba_tab_columns.sample_size%type,
4518: last_analyzed dba_tab_columns.last_analyzed%type,
4519: first_col BOOLEAN)
4520: IS
4521: val1 VARCHAR2(255);
4522: val2 VARCHAR2(255);

Line 4595: FROM dba_tab_columns a1 , dba_tab_columns a2,

4591: BEGIN
4592:
4593: SELECT DISTINCT('EXIST')
4594: INTO exist_flag
4595: FROM dba_tab_columns a1 , dba_tab_columns a2,
4596: dba_tab_columns a3, dba_tab_columns a4,
4597: fnd_oracle_userid b,
4598: fnd_product_installations c
4599: WHERE a1.table_name = upper(tabname)

Line 4596: dba_tab_columns a3, dba_tab_columns a4,

4592:
4593: SELECT DISTINCT('EXIST')
4594: INTO exist_flag
4595: FROM dba_tab_columns a1 , dba_tab_columns a2,
4596: dba_tab_columns a3, dba_tab_columns a4,
4597: fnd_oracle_userid b,
4598: fnd_product_installations c
4599: WHERE a1.table_name = upper(tabname)
4600: AND a2.table_name = upper(tabname)

Line 4619: || ' does not exist in dba_tab_columns for the given application ');

4615: raise_application_error(-20000, 'Column '
4616: || tabname
4617: ||'.'
4618: || colname1
4619: || ' does not exist in dba_tab_columns for the given application ');
4620: WHEN OTHERS THEN
4621: raise_application_error(-20001, 'Error in reading dictionary info. for column '
4622: || tabname
4623: ||'.'

Line 4774: FROM dba_tab_columns

4770: NUM_NULLS ,
4771: DENSITY ,
4772: SAMPLE_SIZE ,
4773: LAST_ANALYZED
4774: FROM dba_tab_columns
4775: WHERE owner = schema
4776: AND table_name = tableName
4777: ORDER BY column_name;
4778: