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 FND_PRODUCT_INSTALLATIONS

Line 37: fnd_product_installations b

33: UNION ALL
34:
35: SELECT DISTINCT upper(oracle_username) sname
36: FROM fnd_oracle_userid a,
37: fnd_product_installations b
38: WHERE a.oracle_id = b.oracle_id
39: ORDER BY sname;
40:
41: /************************************************************************/

Line 552: FND_PRODUCT_INSTALLATIONS c

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
555: order by ownname, tabname, column_name;
556: */

Line 565: FND_PRODUCT_INSTALLATIONS c

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 (+)
568: ORDER BY ownname,
569: tabname,

Line 887: fnd_product_installations fpi

883: AND NOT EXISTS
884: (SELECT NULL
885: FROM fnd_exclude_table_stats fets,
886: fnd_oracle_userid fou ,
887: fnd_product_installations fpi
888: WHERE fou.oracle_username=upper(schemaname)
889: AND fou.oracle_id =fpi.oracle_id
890: AND fpi.application_id = fets.application_id
891: AND dt.table_name = fets.table_name

Line 997: fnd_product_installations fpi

993: AND NOT EXISTS
994: (SELECT NULL
995: FROM fnd_exclude_table_stats fets,
996: fnd_oracle_userid fou ,
997: fnd_product_installations fpi
998: WHERE fou.oracle_username=upper(schemaname)
999: AND fou.oracle_id =fpi.oracle_id
1000: AND fpi.application_id = fets.application_id
1001: AND dt.table_name = fets.table_name

Line 1114: fnd_product_installations fpi

1110: AND NOT EXISTS
1111: (SELECT NULL
1112: FROM fnd_exclude_table_stats fets,
1113: fnd_oracle_userid fou ,
1114: fnd_product_installations fpi
1115: WHERE fou.oracle_username=upper(schemaname)
1116: AND fou.oracle_id =fpi.oracle_id
1117: AND fpi.application_id = fets.application_id
1118: AND dt.table_name = fets.table_name

Line 1387: fnd_product_installations fpi

1383: AND NOT EXISTS
1384: (SELECT NULL
1385: FROM fnd_exclude_table_stats fets,
1386: fnd_oracle_userid fou ,
1387: fnd_product_installations fpi
1388: WHERE fou.oracle_username=upper(schemaname)
1389: AND fou.oracle_id =fpi.oracle_id
1390: AND fpi.application_id = fets.application_id
1391: AND dt.table_name = fets.table_name

Line 1783: fnd_product_installations fpi

1779: AND NOT EXISTS
1780: (SELECT NULL
1781: FROM fnd_exclude_table_stats fets,
1782: fnd_oracle_userid fou ,
1783: fnd_product_installations fpi
1784: WHERE fou.oracle_username=upper(schemaname)
1785: AND fou.oracle_id =fpi.oracle_id
1786: AND fpi.application_id = fets.application_id
1787: AND dt.table_name = fets.table_name

Line 1815: fnd_product_installations fpi

1811: AND NOT EXISTS
1812: (SELECT NULL
1813: FROM fnd_exclude_table_stats fets,
1814: fnd_oracle_userid fou ,
1815: fnd_product_installations fpi
1816: WHERE fou.oracle_username=upper(schemaname)
1817: AND fou.oracle_id =fpi.oracle_id
1818: AND fpi.application_id =fets.application_id
1819: AND di.table_name =fets.table_name

Line 1904: fnd_product_installations fpi

1900: AND NOT EXISTS
1901: (SELECT NULL
1902: FROM fnd_exclude_table_stats fets,
1903: fnd_oracle_userid fou ,
1904: fnd_product_installations fpi
1905: WHERE fou.oracle_username=upper(schemaname)
1906: AND fou.oracle_id =fpi.oracle_id
1907: AND fpi.application_id = fets.application_id
1908: AND dt.table_name = fets.table_name

Line 2026: fnd_product_installations fpi

2022: AND NOT EXISTS
2023: (SELECT NULL
2024: FROM fnd_exclude_table_stats fets,
2025: fnd_oracle_userid fou ,
2026: fnd_product_installations fpi
2027: WHERE fou.oracle_username=upper(schemaname)
2028: AND fou.oracle_id =fpi.oracle_id
2029: AND fpi.application_id = fets.application_id
2030: AND dt.table_name = fets.table_name

Line 2272: fnd_product_installations fpi

2268: AND NOT EXISTS
2269: (SELECT NULL
2270: FROM fnd_exclude_table_stats fets,
2271: fnd_oracle_userid fou ,
2272: fnd_product_installations fpi
2273: WHERE fou.oracle_username=upper(schemaname)
2274: AND fou.oracle_id =fpi.oracle_id
2275: AND fpi.application_id = fets.application_id
2276: AND dt.table_name = fets.table_name

Line 3061: FND_PRODUCT_INSTALLATIONS c

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 (+)
3064: AND c.oracle_id = b.oracle_id (+)
3065: AND a.table_name = upper(tabname)

Line 3186: FND_PRODUCT_INSTALLATIONS c

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: (
3189: b.oracle_username= upper(ownname)
3190: OR a.owner =upper(ownname)

Line 3556: FROM fnd_product_installations a,

3552: FROM dba_tables
3553: WHERE table_name = upper(tabname)
3554: AND owner =
3555: ( SELECT b.oracle_username
3556: FROM fnd_product_installations a,
3557: fnd_oracle_userid b
3558: WHERE a.application_id = appl_id
3559: AND b.oracle_id = a.oracle_id
3560: );

Line 3635: fnd_product_installations c

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)
3638: AND c.application_id = appl_id
3639: AND c.oracle_id = b.oracle_id

Line 4598: fnd_product_installations c

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)
4601: AND a3.table_name = upper(tabname)
4602: AND a4.table_name = upper(tabname)

Line 4753: fnd_product_installations c

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
4756: and b.oracle_username = schema
4757: and a.table_name = tableName