[Home] [Help]
2313: FROM EGO_ITM_USR_ATTR_INTRFC INTF
2314: WHERE INTF.DATA_SET_ID = p_data_set_id
2315: AND INTF.PROCESS_STATUS = G_PS_STYLE_VARIANT_IN_PROCESS
2316: AND NOT EXISTS (SELECT NULL
2317: FROM FND_DESCR_FLEX_COLUMN_USAGES FL_COL
2318: WHERE FL_COL.DESCRIPTIVE_FLEXFIELD_NAME = INTF.ATTR_GROUP_TYPE
2319: AND FL_COL.DESCRIPTIVE_FLEX_CONTEXT_CODE = INTF.ATTR_GROUP_INT_NAME
2320: AND FL_COL.END_USER_COLUMN_NAME = INTF.ATTR_INT_NAME
2321: AND FL_COL.APPLICATION_ID = 431
2341: ATTR.ATTR_ID AS ATTRIBUTE_ID
2342: FROM
2343: EGO_ITM_USR_ATTR_INTRFC INTF,
2344: EGO_FND_DF_COL_USGS_EXT ATTR,
2345: FND_DESCR_FLEX_COLUMN_USAGES FL_COL,
2346: MTL_SYSTEM_ITEMS_B MSIB
2347: WHERE INTF.ATTR_GROUP_TYPE = ATTR.DESCRIPTIVE_FLEXFIELD_NAME
2348: AND INTF.ATTR_GROUP_INT_NAME = ATTR.DESCRIPTIVE_FLEX_CONTEXT_CODE
2349: AND ATTR.APPLICATION_ID = 431
3083: EGO_FND_DSC_FLX_CTX_EXT AG_EXT,
3084: EGO_ITM_USR_ATTR_INTRFC INTF,
3085: EGO_STYLE_VARIANT_ATTR_VS SVA,
3086: EGO_FND_DF_COL_USGS_EXT ATTR,
3087: FND_DESCR_FLEX_COLUMN_USAGES FL_COL,
3088: MTL_SYSTEM_ITEMS_INTERFACE MSII
3089: WHERE INTF.DATA_SET_ID = p_data_set_id
3090: AND INTF.PROCESS_STATUS = G_PS_IN_PROCESS
3091: AND INTF.ATTR_GROUP_TYPE = ATTR.DESCRIPTIVE_FLEXFIELD_NAME
3975: attr_ext.APPLICATION_COLUMN_NAME AS DATABASE_COLUMN,
3976: attr_ext.UOM_CLASS AS UOM_CLASS,
3977: ag_ext.MULTI_ROW
3978: FROM
3979: FND_DESCR_FLEX_COLUMN_USAGES attr_col,
3980: EGO_FND_DF_COL_USGS_EXT attr_ext,
3981: EGO_FND_DSC_FLX_CTX_EXT ag_ext
3982: WHERE ag_ext.ATTR_GROUP_ID = c_attr_group_id
3983: AND ag_ext.DESCRIPTIVE_FLEXFIELD_NAME = attr_ext.DESCRIPTIVE_FLEXFIELD_NAME
4300: #'|| l_prog_int_char1_value|| q'# AS PROG_INT_CHAR1,
4301: #'|| l_prog_int_num4_value|| q'# AS PROG_INT_NUM4,
4302: src.BUNDLE_ID
4303: FROM (#' || p_source_entity_sql || q'#) src,
4304: FND_DESCR_FLEX_COLUMN_USAGES attr_col,
4305: EGO_FND_DSC_FLX_CTX_EXT ag_ext #';
4306:
4307: l_where_clause := q'#
4308: WHERE src.ATTR_GROUP_ID = #' || l_curr_attr_grp_id || q'#