[Home] [Help]
31: UNION ALL
32:
33: SELECT DISTINCT upper(oracle_username) sname
34: FROM fnd_oracle_userid a,
35: fnd_product_installations b
36: WHERE a.oracle_id = b.oracle_id
37: ORDER BY sname;
38:
39: /************************************************************************/
546: a.column_name colname,
547: a.partition partname
548: from FND_HISTOGRAM_COLS a,
549: FND_ORACLE_USERID b,
550: FND_PRODUCT_INSTALLATIONS c
551: where a.application_id = c.application_id
552: and c.oracle_id = b.oracle_id
553: order by ownname, tabname, column_name;
554: */
559: a.column_name colname ,
560: a.partition partname
561: FROM FND_HISTOGRAM_COLS a,
562: FND_ORACLE_USERID b ,
563: FND_PRODUCT_INSTALLATIONS c
564: WHERE a.application_id = c.application_id (+)
565: AND c.oracle_id = b.oracle_id (+)
566: ORDER BY ownname,
567: tabname,
986: AND NOT EXISTS
987: (SELECT NULL
988: FROM fnd_exclude_table_stats fets,
989: fnd_oracle_userid fou ,
990: fnd_product_installations fpi
991: WHERE fou.oracle_username=upper(schemaname)
992: AND fou.oracle_id =fpi.oracle_id
993: AND fpi.application_id = fets.application_id
994: AND dt.table_name = fets.table_name
1344: AND NOT EXISTS
1345: (SELECT NULL
1346: FROM fnd_exclude_table_stats fets,
1347: fnd_oracle_userid fou ,
1348: fnd_product_installations fpi
1349: WHERE fou.oracle_username=upper(schemaname)
1350: AND fou.oracle_id =fpi.oracle_id
1351: AND fpi.application_id = fets.application_id
1352: AND dt.table_name = fets.table_name
1369: AND NOT EXISTS
1370: (SELECT NULL
1371: FROM fnd_exclude_table_stats fets,
1372: fnd_oracle_userid fou ,
1373: fnd_product_installations fpi
1374: WHERE fou.oracle_username=upper(schemaname)
1375: AND fou.oracle_id =fpi.oracle_id
1376: AND fpi.application_id =fets.application_id
1377: AND di.table_name =fets.table_name
1476: AND NOT EXISTS
1477: (SELECT NULL
1478: FROM fnd_exclude_table_stats fets,
1479: fnd_oracle_userid fou ,
1480: fnd_product_installations fpi
1481: WHERE fou.oracle_username=upper(schemaname)
1482: AND fou.oracle_id =fpi.oracle_id
1483: AND fpi.application_id = fets.application_id
1484: AND dt.table_name = fets.table_name
2109: NVL(a.hsize,254) hsize,
2110: NVL(a.owner, upper(b.oracle_username)) ownname
2111: FROM FND_HISTOGRAM_COLS a,
2112: FND_ORACLE_USERID b ,
2113: FND_PRODUCT_INSTALLATIONS c
2114: WHERE a.application_id = appl_id
2115: AND a.application_id = c.application_id (+)
2116: AND c.oracle_id = b.oracle_id (+)
2117: AND a.table_name = upper(tabname)
2233: SELECT DISTINCT a.table_name,
2234: a.application_id
2235: FROM FND_HISTOGRAM_COLS a,
2236: FND_ORACLE_USERID b ,
2237: FND_PRODUCT_INSTALLATIONS c
2238: WHERE
2239: (
2240: b.oracle_username= upper(ownname)
2241: OR a.owner =upper(ownname)
2599: FROM dba_tables
2600: WHERE table_name = upper(tabname)
2601: AND owner =
2602: ( SELECT b.oracle_username
2603: FROM fnd_product_installations a,
2604: fnd_oracle_userid b
2605: WHERE a.application_id = appl_id
2606: AND b.oracle_id = a.oracle_id
2607: );
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)
2685: AND c.application_id = appl_id
2686: AND c.oracle_id = b.oracle_id
3638: /*cursor all_histograms(schema varchar2, tableName varchar2) is
3639: select a.column_name
3640: from fnd_histogram_cols a,
3641: fnd_oracle_userid b,
3642: fnd_product_installations c
3643: where a.application_id = c.application_id
3644: and c.oracle_id = b.oracle_id
3645: and b.oracle_username = schema
3646: and a.table_name = tableName