DBA Data[Home] [Help]

APPS.OE_DEFAULTING_FWK_PUB dependencies on AK_FOREIGN_KEYS

Line 411: FROM AK_FOREIGN_KEYS fk, AK_UNIQUE_KEYS uk, OE_AK_OBJECTS_EXT obj

407: ,uk.database_object_name uk_database_object_name
408: ,fk.foreign_key_name
409: ,obj.entity_code uk_entity_code
410: , obj.defaulting_enabled_flag uk_obj_defaulting_enabled
411: FROM AK_FOREIGN_KEYS fk, AK_UNIQUE_KEYS uk, OE_AK_OBJECTS_EXT obj
412: WHERE fk.database_object_name= p_database_object_name
413: AND fk.application_id= p_application_id
414: AND fk.unique_key_name = uk.unique_key_name
415: AND fk.application_id = uk.application_id

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