DBA Data[Home] [Help]

APPS.OE_DEFAULTING_FWK_PUB dependencies on AK_FOREIGN_KEY_COLUMNS

Line 1277: , AK_FOREIGN_KEYS fk, AK_FOREIGN_KEY_COLUMNS fc

1273:
1274: CURSOR C_UK_COLS IS
1275: SELECT ua.column_name, fa.column_name
1276: FROM AK_UNIQUE_KEYS uk, AK_UNIQUE_KEY_COLUMNS uc
1277: , AK_FOREIGN_KEYS fk, AK_FOREIGN_KEY_COLUMNS fc
1278: , AK_OBJECT_ATTRIBUTES ua, AK_OBJECT_ATTRIBUTES fa
1279: WHERE uk.database_object_name = l_src_database_object_name
1280: AND uk.unique_key_name = uc.unique_key_name
1281: AND fk.database_object_name = p_database_object_name

Line 2201: FROM ak_object_attributes_vl b,ak_foreign_key_columns a

2197: l_database_object_name varchar2)
2198: IS
2199: SELECT b.attribute_code, b.column_name,
2200: foreign_key_sequence, b.data_type
2201: FROM ak_object_attributes_vl b,ak_foreign_key_columns a
2202: WHERE a.foreign_key_name= l_fk_name
2203: AND b.database_object_name = l_database_object_name
2204: AND b.attribute_application_id = a.attribute_application_id
2205: AND b.attribute_code = a.attribute_code