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.FEM_DATAX_LOADER_PKG dependencies on FEM_XDIM_DIMENSIONS

Line 1640: fem_xdim_dimensions X

1636: BEGIN
1637: SELECT member_b_table_name,member_col,member_display_code_col
1638: INTO v_cctr_org_b_tab,v_cctr_org_col,v_cctr_org_dc_col
1639: FROM fem_tab_columns_b C,
1640: fem_xdim_dimensions X
1641: WHERE C.table_name = g_data_table
1642: AND C.column_name = 'COMPANY_COST_CENTER_ORG_ID'
1643: AND C.dimension_id = X.dimension_id;
1644:

Line 1661: fem_xdim_dimensions X

1657: BEGIN
1658: SELECT member_b_table_name,member_col,member_display_code_col
1659: INTO v_fin_elem_b_tab,v_fin_elem_col,v_fin_elem_dc_col
1660: FROM fem_tab_columns_b C,
1661: fem_xdim_dimensions X
1662: WHERE C.table_name = g_data_table
1663: AND C.column_name = 'FINANCIAL_ELEM_ID'
1664: AND C.dimension_id = X.dimension_id;
1665:

Line 1682: fem_xdim_dimensions X

1678: BEGIN
1679: SELECT member_b_table_name,member_col,member_display_code_col
1680: INTO v_product_b_tab,v_product_col,v_product_dc_col
1681: FROM fem_tab_columns_b C,
1682: fem_xdim_dimensions X
1683: WHERE C.table_name = g_data_table
1684: AND C.column_name = 'PRODUCT_ID'
1685: AND C.dimension_id = X.dimension_id;
1686:

Line 1703: fem_xdim_dimensions X

1699: BEGIN
1700: SELECT member_b_table_name,member_col,member_display_code_col
1701: INTO v_nat_acct_b_tab,v_nat_acct_col,v_nat_acct_dc_col
1702: FROM fem_tab_columns_b C,
1703: fem_xdim_dimensions X
1704: WHERE C.table_name = g_data_table
1705: AND C.column_name = 'NATURAL_ACCOUNT_ID'
1706: AND C.dimension_id = X.dimension_id;
1707:

Line 1724: fem_xdim_dimensions X

1720: BEGIN
1721: SELECT member_b_table_name,member_col,member_display_code_col
1722: INTO v_channel_b_tab,v_channel_col,v_channel_dc_col
1723: FROM fem_tab_columns_b C,
1724: fem_xdim_dimensions X
1725: WHERE C.table_name = g_data_table
1726: AND C.column_name = 'CHANNEL_ID'
1727: AND C.dimension_id = X.dimension_id;
1728:

Line 1745: fem_xdim_dimensions X

1741: BEGIN
1742: SELECT member_b_table_name,member_col,member_display_code_col
1743: INTO v_line_item_b_tab,v_line_item_col,v_line_item_dc_col
1744: FROM fem_tab_columns_b C,
1745: fem_xdim_dimensions X
1746: WHERE C.table_name = g_data_table
1747: AND C.column_name = 'LINE_ITEM_ID'
1748: AND C.dimension_id = X.dimension_id;
1749:

Line 1766: fem_xdim_dimensions X

1762: BEGIN
1763: SELECT member_b_table_name,member_col,member_display_code_col
1764: INTO v_project_b_tab,v_project_col,v_project_dc_col
1765: FROM fem_tab_columns_b C,
1766: fem_xdim_dimensions X
1767: WHERE C.table_name = g_data_table
1768: AND C.column_name = 'PROJECT_ID'
1769: AND C.dimension_id = X.dimension_id;
1770:

Line 1787: fem_xdim_dimensions X

1783: BEGIN
1784: SELECT member_b_table_name,member_col,member_display_code_col
1785: INTO v_customer_b_tab,v_customer_col,v_customer_dc_col
1786: FROM fem_tab_columns_b C,
1787: fem_xdim_dimensions X
1788: WHERE C.table_name = g_data_table
1789: AND C.column_name = 'CUSTOMER_ID'
1790: AND C.dimension_id = X.dimension_id;
1791:

Line 1808: fem_xdim_dimensions X

1804: BEGIN
1805: SELECT member_b_table_name,member_col,member_display_code_col
1806: INTO v_entity_b_tab,v_entity_col,v_entity_dc_col
1807: FROM fem_tab_columns_b C,
1808: fem_xdim_dimensions X
1809: WHERE C.table_name = g_data_table
1810: AND C.column_name = 'ENTITY_ID'
1811: AND C.dimension_id = X.dimension_id;
1812:

Line 1829: fem_xdim_dimensions X

1825: BEGIN
1826: SELECT member_b_table_name,member_col,member_display_code_col
1827: INTO v_geography_b_tab,v_geography_col,v_geography_dc_col
1828: FROM fem_tab_columns_b C,
1829: fem_xdim_dimensions X
1830: WHERE C.table_name = g_data_table
1831: AND C.column_name = 'GEOGRAPHY_ID'
1832: AND C.dimension_id = X.dimension_id;
1833:

Line 1850: fem_xdim_dimensions X

1846: BEGIN
1847: SELECT member_b_table_name,member_col,member_display_code_col
1848: INTO v_task_b_tab,v_task_col,v_task_dc_col
1849: FROM fem_tab_columns_b C,
1850: fem_xdim_dimensions X
1851: WHERE C.table_name = g_data_table
1852: AND C.column_name = 'TASK_ID'
1853: AND C.dimension_id = X.dimension_id;
1854:

Line 1871: fem_xdim_dimensions X

1867: BEGIN
1868: SELECT member_b_table_name,member_col,member_display_code_col
1869: INTO v_interco_b_tab,v_interco_col,v_interco_dc_col
1870: FROM fem_tab_columns_b C,
1871: fem_xdim_dimensions X
1872: WHERE C.table_name = g_data_table
1873: AND C.column_name = 'INTERCOMPANY_ID'
1874: AND C.dimension_id = X.dimension_id;
1875:

Line 1892: fem_xdim_dimensions X

1888: BEGIN
1889: SELECT member_b_table_name,member_col,member_display_code_col
1890: INTO v_user_dim1_b_tab,v_user_dim1_col,v_user_dim1_dc_col
1891: FROM fem_tab_columns_b C,
1892: fem_xdim_dimensions X
1893: WHERE C.table_name = g_data_table
1894: AND C.column_name = 'USER_DIM1_ID'
1895: AND C.dimension_id = X.dimension_id;
1896:

Line 1913: fem_xdim_dimensions X

1909: BEGIN
1910: SELECT member_b_table_name,member_col,member_display_code_col
1911: INTO v_user_dim2_b_tab,v_user_dim2_col,v_user_dim2_dc_col
1912: FROM fem_tab_columns_b C,
1913: fem_xdim_dimensions X
1914: WHERE C.table_name = g_data_table
1915: AND C.column_name = 'USER_DIM2_ID'
1916: AND C.dimension_id = X.dimension_id;
1917:

Line 1934: fem_xdim_dimensions X

1930: BEGIN
1931: SELECT member_b_table_name,member_col,member_display_code_col
1932: INTO v_user_dim3_b_tab,v_user_dim3_col,v_user_dim3_dc_col
1933: FROM fem_tab_columns_b C,
1934: fem_xdim_dimensions X
1935: WHERE C.table_name = g_data_table
1936: AND C.column_name = 'USER_DIM3_ID'
1937: AND C.dimension_id = X.dimension_id;
1938:

Line 1955: fem_xdim_dimensions X

1951: BEGIN
1952: SELECT member_b_table_name,member_col,member_display_code_col
1953: INTO v_user_dim4_b_tab,v_user_dim4_col,v_user_dim4_dc_col
1954: FROM fem_tab_columns_b C,
1955: fem_xdim_dimensions X
1956: WHERE C.table_name = g_data_table
1957: AND C.column_name = 'USER_DIM4_ID'
1958: AND C.dimension_id = X.dimension_id;
1959:

Line 1976: fem_xdim_dimensions X

1972: BEGIN
1973: SELECT member_b_table_name,member_col,member_display_code_col
1974: INTO v_user_dim5_b_tab,v_user_dim5_col,v_user_dim5_dc_col
1975: FROM fem_tab_columns_b C,
1976: fem_xdim_dimensions X
1977: WHERE C.table_name = g_data_table
1978: AND C.column_name = 'USER_DIM5_ID'
1979: AND C.dimension_id = X.dimension_id;
1980:

Line 1997: fem_xdim_dimensions X

1993: BEGIN
1994: SELECT member_b_table_name,member_col,member_display_code_col
1995: INTO v_user_dim6_b_tab,v_user_dim6_col,v_user_dim6_dc_col
1996: FROM fem_tab_columns_b C,
1997: fem_xdim_dimensions X
1998: WHERE C.table_name = g_data_table
1999: AND C.column_name = 'USER_DIM6_ID'
2000: AND C.dimension_id = X.dimension_id;
2001:

Line 2018: fem_xdim_dimensions X

2014: BEGIN
2015: SELECT member_b_table_name,member_col,member_display_code_col
2016: INTO v_user_dim7_b_tab,v_user_dim7_col,v_user_dim7_dc_col
2017: FROM fem_tab_columns_b C,
2018: fem_xdim_dimensions X
2019: WHERE C.table_name = g_data_table
2020: AND C.column_name = 'USER_DIM7_ID'
2021: AND C.dimension_id = X.dimension_id;
2022:

Line 2039: fem_xdim_dimensions X

2035: BEGIN
2036: SELECT member_b_table_name,member_col,member_display_code_col
2037: INTO v_user_dim8_b_tab,v_user_dim8_col,v_user_dim8_dc_col
2038: FROM fem_tab_columns_b C,
2039: fem_xdim_dimensions X
2040: WHERE C.table_name = g_data_table
2041: AND C.column_name = 'USER_DIM8_ID'
2042: AND C.dimension_id = X.dimension_id;
2043:

Line 2060: fem_xdim_dimensions X

2056: BEGIN
2057: SELECT member_b_table_name,member_col,member_display_code_col
2058: INTO v_user_dim9_b_tab,v_user_dim9_col,v_user_dim9_dc_col
2059: FROM fem_tab_columns_b C,
2060: fem_xdim_dimensions X
2061: WHERE C.table_name = g_data_table
2062: AND C.column_name = 'USER_DIM9_ID'
2063: AND C.dimension_id = X.dimension_id;
2064:

Line 2081: fem_xdim_dimensions X

2077: BEGIN
2078: SELECT member_b_table_name,member_col,member_display_code_col
2079: INTO v_user_dim10_b_tab,v_user_dim10_col,v_user_dim10_dc_col
2080: FROM fem_tab_columns_b C,
2081: fem_xdim_dimensions X
2082: WHERE C.table_name = g_data_table
2083: AND C.column_name = 'USER_DIM10_ID'
2084: AND C.dimension_id = X.dimension_id;
2085: