APPS.OE_DEFAULTING_FWK_PUB dependencies on AK_OBJECT_ATTRIBUTES_VL

Line 440: , AK_OBJECT_ATTRIBUTES_VL ak

436: oe.security_api_proc,
437: oe.defaulting_condn_ref_flag,
438: oe.defaulting_enabled_flag
439: FROM OE_AK_OBJ_ATTR_EXT OE
440: , AK_OBJECT_ATTRIBUTES_VL ak
441: WHERE oe.database_object_name = p_database_object_name
442: AND oe.attribute_application_id = p_application_id
443: AND ak.database_object_name = oe.database_object_name
444: AND ak.attribute_code = oe.attribute_code

Line 2173: FROM AK_OBJECT_ATTRIBUTES_VL aoj

2169: CURSOR OASV (p_database_object_name varchar2,p_application_id number)
2170: is
2171: SELECT aoj.attribute_code,NVL(aoj.data_type,'VARCHAR2')data_type,
2172: aoj.column_name
2173: FROM AK_OBJECT_ATTRIBUTES_VL aoj
2174: WHERE aoj.database_object_name = p_database_object_name
2175: AND aoj.attribute_application_id = p_application_id
2176: AND aoj.column_name is not null;
2177:

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

Line 2224: FROM ak_object_attributes_vl oa

2220: FROM OE_DEF_AK_FKEYS_V fk
2221: WHERE fk_database_object_name=l_database_object_name
2222: AND application_id=p_application_id
2223: AND exists (SELECT 'Y'
2224: FROM ak_object_attributes_vl oa
2225: WHERE oa.database_object_name = fk.uk_database_object_name
2226: AND oa.data_type = 'DATE'
2227: );
2228: --