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 2680: FROM dba_tab_columns a ,

2676: -- break out if it doesn't exist
2677: BEGIN
2678: SELECT DISTINCT('EXIST')
2679: INTO exist_flag
2680: FROM dba_tab_columns a ,
2681: fnd_oracle_userid b,
2682: fnd_product_installations c
2683: WHERE a.table_name = upper(tabname)
2684: AND a.column_name = upper(colname)

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

2691: raise_application_error(-20000, 'Column '
2692: || tabname
2693: ||'.'
2694: || colname
2695: || ' does not exist in dba_tab_columns for the given application ');
2696: WHEN OTHERS THEN
2697: raise_application_error(-20001, 'Error in reading dictionary info. for column '
2698: || tabname
2699: ||'.'

Line 2779: FROM dba_tab_columns a

2775: -- break out if it doesn't exist
2776: BEGIN
2777: SELECT DISTINCT('EXIST')
2778: INTO exist_flag
2779: FROM dba_tab_columns a
2780: WHERE a.table_name = upper(tabname)
2781: AND a.column_name = upper(colname)
2782: AND a.owner = upper(ownername);
2783:

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

2786: raise_application_error(-20000, 'Column '
2787: || tabname
2788: ||'.'
2789: || colname
2790: || ' does not exist in dba_tab_columns for the given owner ');
2791: WHEN OTHERS THEN
2792: raise_application_error(-20001, 'Error in reading dictionary info. for column '
2793: || tabname
2794: ||'.'

Line 3500: last_analyzed dba_tab_columns.last_analyzed%type;

3496: IS
3497: found0 BOOLEAN := false;
3498: found1 BOOLEAN := false;
3499: status VARCHAR2(64) := 'not present';
3500: last_analyzed dba_tab_columns.last_analyzed%type;
3501: CURSOR histo_details(schema VARCHAR2, tableName VARCHAR2, columnName VARCHAR2)
3502: IS
3503: SELECT endpoint_number,
3504: last_analyzed

Line 3506: dba_tab_columns b

3502: IS
3503: SELECT endpoint_number,
3504: last_analyzed
3505: FROM dba_histograms a,
3506: dba_tab_columns b
3507: WHERE a.owner = schema
3508: AND a.table_name = tableName
3509: AND a.column_name = columnName
3510: AND a.owner = b.owner

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

3556: /* Procedure: column_stats */
3557: /* Desciption: Internal procedures used by verify_stats. Gets info about*/
3558: /* about column stats. */
3559: /************************************************************************/
3560: PROCEDURE column_stats(column_name dba_tab_columns.column_name%type,
3561: num_distinct dba_tab_columns.num_distinct%type,
3562: num_nulls dba_tab_columns.num_nulls%type,
3563: density dba_tab_columns.density%type,
3564: sample_size dba_tab_columns.sample_size%type,

Line 3561: num_distinct dba_tab_columns.num_distinct%type,

3557: /* Desciption: Internal procedures used by verify_stats. Gets info about*/
3558: /* about column stats. */
3559: /************************************************************************/
3560: PROCEDURE column_stats(column_name dba_tab_columns.column_name%type,
3561: num_distinct dba_tab_columns.num_distinct%type,
3562: num_nulls dba_tab_columns.num_nulls%type,
3563: density dba_tab_columns.density%type,
3564: sample_size dba_tab_columns.sample_size%type,
3565: last_analyzed dba_tab_columns.last_analyzed%type,

Line 3562: num_nulls dba_tab_columns.num_nulls%type,

3558: /* about column stats. */
3559: /************************************************************************/
3560: PROCEDURE column_stats(column_name dba_tab_columns.column_name%type,
3561: num_distinct dba_tab_columns.num_distinct%type,
3562: num_nulls dba_tab_columns.num_nulls%type,
3563: density dba_tab_columns.density%type,
3564: sample_size dba_tab_columns.sample_size%type,
3565: last_analyzed dba_tab_columns.last_analyzed%type,
3566: first_col BOOLEAN)

Line 3563: density dba_tab_columns.density%type,

3559: /************************************************************************/
3560: PROCEDURE column_stats(column_name dba_tab_columns.column_name%type,
3561: num_distinct dba_tab_columns.num_distinct%type,
3562: num_nulls dba_tab_columns.num_nulls%type,
3563: density dba_tab_columns.density%type,
3564: sample_size dba_tab_columns.sample_size%type,
3565: last_analyzed dba_tab_columns.last_analyzed%type,
3566: first_col BOOLEAN)
3567: IS

Line 3564: sample_size dba_tab_columns.sample_size%type,

3560: PROCEDURE column_stats(column_name dba_tab_columns.column_name%type,
3561: num_distinct dba_tab_columns.num_distinct%type,
3562: num_nulls dba_tab_columns.num_nulls%type,
3563: density dba_tab_columns.density%type,
3564: sample_size dba_tab_columns.sample_size%type,
3565: last_analyzed dba_tab_columns.last_analyzed%type,
3566: first_col BOOLEAN)
3567: IS
3568: val1 VARCHAR2(255);

Line 3565: last_analyzed dba_tab_columns.last_analyzed%type,

3561: num_distinct dba_tab_columns.num_distinct%type,
3562: num_nulls dba_tab_columns.num_nulls%type,
3563: density dba_tab_columns.density%type,
3564: sample_size dba_tab_columns.sample_size%type,
3565: last_analyzed dba_tab_columns.last_analyzed%type,
3566: first_col BOOLEAN)
3567: IS
3568: val1 VARCHAR2(255);
3569: val2 VARCHAR2(255);

Line 3663: FROM dba_tab_columns

3659: NUM_NULLS ,
3660: DENSITY ,
3661: SAMPLE_SIZE ,
3662: LAST_ANALYZED
3663: FROM dba_tab_columns
3664: WHERE owner = schema
3665: AND table_name = tableName
3666: ORDER BY column_name;
3667: