DBA Data[Home] [Help]

APPS.CN_FORMULA_GEN_PKG dependencies on CN_CALC_EXT_TABLES_ALL

Line 1347: cn_calc_ext_tables_all map

1343: trim( both ' ' FROM lower(obj.alias) ) internal_table_alias,
1344: lower(l_table_name) external_table_name,
1345: lower(l_table_alias) external_table_alias
1346: FROM cn_objects_all obj,
1347: cn_calc_ext_tables_all map
1348: WHERE lower(map.alias) = l_table_alias
1349: AND map.org_id = g_org_id
1350: AND obj.object_id = map.internal_table_id
1351: AND obj.org_id = map.org_id;

Line 1406: FROM cn_calc_ext_tables_all map,

1402: l_sql_where VARCHAR2(1000);
1403:
1404: CURSOR l_all_columns_csr IS
1405: SELECT col.table_id, lower(col.name) column_name
1406: FROM cn_calc_ext_tables_all map,
1407: cn_objects_all col
1408: WHERE map.alias = l_table_alias
1409: AND map.org_id = g_org_id
1410: AND col.table_id = map.external_table_id