[Home] [Help]
786: aa.data_type data_type
787: FROM ak_object_attributes aoa,
788: ak_excluded_items aei,
789: ak_resp_security_attributes arsa,
790: ak_attributes aa,
791: ak_regions ar,
792: ak_region_items_tl arit,
793: ak_region_items ari
794: WHERE ari.object_attribute_flag = 'Y'
854: ari.order_direction order_direction,
855: aa.data_type data_type
856: FROM ak_excluded_items aei,
857: ak_resp_security_attributes arsa,
858: ak_attributes aa,
859: ak_region_items_tl arit,
860: ak_region_items ari
861: WHERE ari.object_attribute_flag <> 'Y'
862: AND ari.region_code = p_child_region_code
2188: SELECT aoa.column_name foreign_key_column_name, aa.data_type
2189: FROM ak_foreign_keys afk,
2190: ak_foreign_key_columns afkc,
2191: ak_object_attributes aoa,
2192: ak_attributes aa
2193: WHERE
2194: afk.database_object_name = aoa.database_object_name
2195: AND afkc.attribute_application_id = aoa.attribute_application_id
2196: AND afkc.attribute_code = aoa.attribute_code
2238: SELECT aoa.column_name unique_key_column_name, aa.data_type
2239: FROM ak_unique_keys auk,
2240: ak_unique_key_columns aukc,
2241: ak_object_attributes aoa,
2242: ak_attributes aa
2243: WHERE
2244: auk.database_object_name = aoa.database_object_name
2245: AND aukc.attribute_application_id = aoa.attribute_application_id
2246: AND aukc.attribute_code = aoa.attribute_code
2526: aa.data_type data_type
2527: FROM ak_object_attributes aoa,
2528: ak_excluded_items aei,
2529: ak_resp_security_attributes arsa,
2530: ak_attributes aa,
2531: ak_regions ar,
2532: ak_region_items_tl arit,
2533: ak_region_items ari
2534: WHERE ari.object_attribute_flag = 'Y'
2596: ari.order_direction order_direction,
2597: aa.data_type data_type
2598: FROM ak_excluded_items aei,
2599: ak_resp_security_attributes arsa,
2600: ak_attributes aa,
2601: ak_region_items_tl arit,
2602: ak_region_items ari
2603: WHERE ari.object_attribute_flag <> 'Y'
2604: AND ari.region_code = p_child_region_code