DBA Data[Home] [Help]

APPS.CN_FORMULA_GEN_PKG dependencies on CN_CALC_EXT_TABLES_ALL

Line 1346: cn_calc_ext_tables_all map

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

Line 1401: FROM cn_calc_ext_tables_all map,

1397: l_sql_where VARCHAR2(1000);
1398:
1399: CURSOR l_all_columns_csr IS
1400: SELECT col.table_id, lower(col.name) column_name
1401: FROM cn_calc_ext_tables_all map,
1402: cn_objects_all col
1403: WHERE map.alias = l_table_alias
1404: AND map.org_id = g_org_id
1405: AND col.table_id = map.external_table_id