APPS.FND_STATS dependencies on FND_HISTOGRAM_COLS

Line 541: /* columns seeded in the fnd_histogram_cols table. */

537: /* RESTORE_COLUMN_STATS() */
538: /************************************************************************/
539: /* Procedure: RESTORE_COLUMN_STATS */
540: /* Desciption: Retores column statistics from fnd_stattab table for all */
541: /* columns seeded in the fnd_histogram_cols table. */
542: /************************************************************************/
543: PROCEDURE RESTORE_COLUMN_STATS(statid IN VARCHAR2 DEFAULT NULL)
544: IS
545: /* cursor col_cursor is

Line 550: from FND_HISTOGRAM_COLS a,

546: select upper(b.oracle_username) ownname ,
547: a.table_name tabname,
548: a.column_name colname,
549: a.partition partname
550: from FND_HISTOGRAM_COLS a,
551: FND_ORACLE_USERID b,
552: FND_PRODUCT_INSTALLATIONS c
553: where a.application_id = c.application_id
554: and c.oracle_id = b.oracle_id

Line 563: FROM FND_HISTOGRAM_COLS a,

559: SELECT NVL(upper(b.oracle_username), a.owner) ownname ,
560: a.table_name tabname ,
561: a.column_name colname ,
562: a.partition partname
563: FROM FND_HISTOGRAM_COLS a,
564: FND_ORACLE_USERID b ,
565: FND_PRODUCT_INSTALLATIONS c
566: WHERE a.application_id = c.application_id (+)
567: AND c.oracle_id = b.oracle_id (+)

Line 2713: FROM FND_HISTOGRAM_COLS a

2709: CURSOR col_cursor (ownname VARCHAR2, tabname VARCHAR2, partname VARCHAR2)
2710: IS
2711: SELECT a.column_name,
2712: NVL(a.hsize,254) hsize
2713: FROM FND_HISTOGRAM_COLS a
2714: WHERE a.table_name = upper(tabname)
2715: AND
2716: (
2717: a.partition = upper(partname)

Line 3028: /* Desciption: Gathers stats for all columns in FND_HISTOGRAM_COLS table*/

3024: END ;
3025: /* GATHER_TABLE_STATS */
3026: /************************************************************************/
3027: /* Procedure: GATHER_COLUMN_STATS */
3028: /* Desciption: Gathers stats for all columns in FND_HISTOGRAM_COLS table*/
3029: /************************************************************************/
3030: PROCEDURE GATHER_COLUMN_STATS(appl_id IN NUMBER DEFAULT NULL,
3031: percent IN NUMBER DEFAULT NULL,
3032: degree IN NUMBER DEFAULT NULL,

Line 3044: FROM FND_HISTOGRAM_COLS a

3040: IS
3041: SELECT DISTINCT a.application_id,
3042: a.table_name ,
3043: a.partition
3044: FROM FND_HISTOGRAM_COLS a
3045: WHERE
3046: (
3047: a.application_id = appl_id
3048: OR appl_id IS NULL

Line 3059: FROM FND_HISTOGRAM_COLS a,

3055: IS
3056: SELECT a.column_name ,
3057: NVL(a.hsize,254) hsize,
3058: NVL(a.owner, upper(b.oracle_username)) ownname
3059: FROM FND_HISTOGRAM_COLS a,
3060: FND_ORACLE_USERID b ,
3061: FND_PRODUCT_INSTALLATIONS c
3062: WHERE a.application_id = appl_id
3063: AND a.application_id = c.application_id (+)

Line 3184: FROM FND_HISTOGRAM_COLS a,

3180: CURSOR tab_cursor (ownname VARCHAR2)
3181: IS
3182: SELECT DISTINCT a.table_name,
3183: a.application_id
3184: FROM FND_HISTOGRAM_COLS a,
3185: FND_ORACLE_USERID b ,
3186: FND_PRODUCT_INSTALLATIONS c
3187: WHERE
3188: (

Line 3201: FROM FND_HISTOGRAM_COLS a

3197: CURSOR col_cursor (appl_id NUMBER, tabname VARCHAR2)
3198: IS
3199: SELECT column_name,
3200: NVL(hsize,254) hsize
3201: FROM FND_HISTOGRAM_COLS a
3202: WHERE a.application_id = appl_id
3203: AND a.table_name = upper(tabname)
3204: ORDER BY 1 ;
3205:

Line 3657: INTO FND_HISTOGRAM_COLS

3653: || colname );
3654: END;
3655: BEGIN
3656: INSERT
3657: INTO FND_HISTOGRAM_COLS
3658: (
3659: APPLICATION_ID ,
3660: TABLE_NAME ,
3661: COLUMN_NAME ,

Line 3692: FROM FND_HISTOGRAM_COLS

3688: END;
3689: elsif upper(action) = 'DELETE' THEN
3690: BEGIN
3691: DELETE
3692: FROM FND_HISTOGRAM_COLS
3693: WHERE application_id = appl_id
3694: AND table_name = upper(tabname)
3695: AND column_name = upper(colname)
3696: AND

Line 3752: INTO FND_HISTOGRAM_COLS

3748: || colname );
3749: END;
3750: BEGIN
3751: INSERT
3752: INTO FND_HISTOGRAM_COLS
3753: (
3754: application_id ,
3755: OWNER ,
3756: TABLE_NAME ,

Line 3789: FROM FND_HISTOGRAM_COLS

3785: END;
3786: elsif upper(action) = 'DELETE' THEN
3787: BEGIN
3788: DELETE
3789: FROM FND_HISTOGRAM_COLS
3790: WHERE owner = upper(ownername)
3791: AND table_name = upper(tabname)
3792: AND column_name = upper(colname)
3793: AND

Line 4751: from fnd_histogram_cols a,

4747: ORDER BY index_name;
4748:
4749: /*cursor all_histograms(schema varchar2, tableName varchar2) is
4750: select a.column_name
4751: from fnd_histogram_cols a,
4752: fnd_oracle_userid b,
4753: fnd_product_installations c
4754: where a.application_id = c.application_id
4755: and c.oracle_id = b.oracle_id

Line 4762: FROM fnd_histogram_cols a

4758: order by a.column_name;*/
4759: CURSOR all_histograms(schema VARCHAR2, tableName VARCHAR2)
4760: IS
4761: SELECT a.column_name
4762: FROM fnd_histogram_cols a
4763: WHERE a.table_name = tableName
4764: ORDER BY a.column_name;
4765:
4766: CURSOR all_columns(schema VARCHAR2, tableName VARCHAR2)