DBA Data[Home] [Help]

APPS.EDW_GEN_VIEW dependencies on EDW_ATTRIBUTE_MAPPINGS

Line 211: from edw_attribute_mappings attr, edw_flex_attribute_mappings flex

207: l_seg_length Integer :=0;
208:
209: CURSOR C_Application_Id(p_obj_name VARCHAR2) IS
210: select distinct application_id
211: from edw_attribute_mappings attr, edw_flex_attribute_mappings flex
212: where attr.attr_mapping_pk = flex.attr_mapping_fk
213: and object_short_name = p_obj_name;
214:
215: CURSOR C_Context_Code(p_id_flex_code VARCHAR2, p_application_id NUMBER, p_struct_num NUMBER) IS

Line 768: /* access edw_attribute mappings and get the list */

764: fk c_getFactFlexFKMaps%ROWTYPE;
765: l_count number;
766:
767: BEGIN
768: /* access edw_attribute mappings and get the list */
769:
770: IF (g_log) THEN
771:
772: indentBegin;

Line 1155: from edw_attribute_mappings a, edw_flex_attribute_mappings b

1151: pFlexType IN VARCHAR2) RETURN VARCHAR2 IS
1152:
1153: CURSOR c1(pView IN varchar2, pAttr IN varchar2) IS
1154: SELECT distinct structure_num, segment_name, structure_name, VALUE_SET_DATATYPE
1155: from edw_attribute_mappings a, edw_flex_attribute_mappings b
1156: where upper(a.source_view) = upper(pView)
1157: and upper(a.attribute_name) = upper(pAttr)
1158: and a.attr_mapping_pk = b.attr_mapping_fk;
1159: