[Home] [Help]
1879: FROM EGO_ITM_USR_ATTR_INTRFC INTF
1880: WHERE INTF.DATA_SET_ID = p_data_set_id
1881: AND INTF.PROCESS_STATUS = G_PS_STYLE_VARIANT_IN_PROCESS
1882: AND NOT EXISTS (SELECT NULL
1883: FROM FND_DESCR_FLEX_COLUMN_USAGES FL_COL
1884: WHERE FL_COL.DESCRIPTIVE_FLEXFIELD_NAME = INTF.ATTR_GROUP_TYPE
1885: AND FL_COL.DESCRIPTIVE_FLEX_CONTEXT_CODE = INTF.ATTR_GROUP_INT_NAME
1886: AND FL_COL.END_USER_COLUMN_NAME = INTF.ATTR_INT_NAME
1887: AND FL_COL.APPLICATION_ID = 431
1907: ATTR.ATTR_ID AS ATTRIBUTE_ID
1908: FROM
1909: EGO_ITM_USR_ATTR_INTRFC INTF,
1910: EGO_FND_DF_COL_USGS_EXT ATTR,
1911: FND_DESCR_FLEX_COLUMN_USAGES FL_COL,
1912: MTL_SYSTEM_ITEMS_B MSIB
1913: WHERE INTF.ATTR_GROUP_TYPE = ATTR.DESCRIPTIVE_FLEXFIELD_NAME
1914: AND INTF.ATTR_GROUP_INT_NAME = ATTR.DESCRIPTIVE_FLEX_CONTEXT_CODE
1915: AND ATTR.APPLICATION_ID = 431
2431: EGO_FND_DSC_FLX_CTX_EXT AG_EXT,
2432: EGO_ITM_USR_ATTR_INTRFC INTF,
2433: EGO_STYLE_VARIANT_ATTR_VS SVA,
2434: EGO_FND_DF_COL_USGS_EXT ATTR,
2435: FND_DESCR_FLEX_COLUMN_USAGES FL_COL,
2436: MTL_SYSTEM_ITEMS_INTERFACE MSII
2437: WHERE INTF.DATA_SET_ID = p_data_set_id
2438: AND INTF.PROCESS_STATUS = G_PS_IN_PROCESS
2439: AND INTF.ATTR_GROUP_TYPE = ATTR.DESCRIPTIVE_FLEXFIELD_NAME
3227: attr_ext.APPLICATION_COLUMN_NAME AS DATABASE_COLUMN,
3228: attr_ext.UOM_CLASS AS UOM_CLASS,
3229: ag_ext.MULTI_ROW
3230: FROM
3231: FND_DESCR_FLEX_COLUMN_USAGES attr_col,
3232: EGO_FND_DF_COL_USGS_EXT attr_ext,
3233: EGO_FND_DSC_FLX_CTX_EXT ag_ext
3234: WHERE ag_ext.ATTR_GROUP_ID = c_attr_group_id
3235: AND ag_ext.DESCRIPTIVE_FLEXFIELD_NAME = attr_ext.DESCRIPTIVE_FLEXFIELD_NAME
3545: #'|| l_prog_int_char1_value|| q'# AS PROG_INT_CHAR1,
3546: #'|| l_prog_int_num4_value|| q'# AS PROG_INT_NUM4,
3547: src.BUNDLE_ID
3548: FROM (#' || p_source_entity_sql || q'#) src,
3549: FND_DESCR_FLEX_COLUMN_USAGES attr_col,
3550: EGO_FND_DSC_FLX_CTX_EXT ag_ext #';
3551:
3552: l_where_clause := q'#
3553: WHERE src.ATTR_GROUP_ID = #' || l_curr_attr_grp_id || q'#