APPS.EGO_ITEM_USER_ATTRS_CP_PUB dependencies on EGO_FND_DSC_FLX_CTX_EXT

Line 1148: FROM EGO_FND_DSC_FLX_CTX_EXT

1144: -- Find the Attr Group Type for Attribute Name --
1145: ---------------------------------------------------------
1146: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI
1147: SET ATTR_GROUP_TYPE = NVL(ATTR_GROUP_TYPE,(SELECT DESCRIPTIVE_FLEXFIELD_NAME
1148: FROM EGO_FND_DSC_FLX_CTX_EXT
1149: WHERE APPLICATION_ID = 431
1150: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = UAI.ATTR_GROUP_INT_NAME
1151: AND ROWNUM = 1))
1152: ,PROCESS_STATUS = DECODE((SELECT COUNT(DESCRIPTIVE_FLEXFIELD_NAME)

Line 1153: FROM EGO_FND_DSC_FLX_CTX_EXT

1149: WHERE APPLICATION_ID = 431
1150: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = UAI.ATTR_GROUP_INT_NAME
1151: AND ROWNUM = 1))
1152: ,PROCESS_STATUS = DECODE((SELECT COUNT(DESCRIPTIVE_FLEXFIELD_NAME)
1153: FROM EGO_FND_DSC_FLX_CTX_EXT
1154: WHERE APPLICATION_ID = 431
1155: AND (UAI.ATTR_GROUP_TYPE IS NULL OR UAI.ATTR_GROUP_TYPE=DESCRIPTIVE_FLEXFIELD_NAME)
1156: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = UAI.ATTR_GROUP_INT_NAME),
1157: 1,PROCESS_STATUS

Line 1179: -- FROM EGO_FND_DSC_FLX_CTX_EXT FLX_EXT

1175: -- WHERE UAI.DATA_SET_ID = p_data_set_id
1176: -- AND UAI.PROCESS_STATUS = G_PS_IN_PROCESS
1177: -- AND UAI.ATTR_GROUP_ID IS NOT NULL
1178: -- AND UAI.ATTR_GROUP_ID <> ( SELECT ATTR_GROUP_ID
1179: -- FROM EGO_FND_DSC_FLX_CTX_EXT FLX_EXT
1180: -- WHERE APPLICATION_ID = 431
1181: -- AND DESCRIPTIVE_FLEXFIELD_NAME = l_attr_group_type
1182: -- AND DESCRIPTIVE_FLEX_CONTEXT_CODE = UAI.ATTR_GROUP_INT_NAME);
1183:

Line 1192: FROM EGO_FND_DSC_FLX_CTX_EXT FLX_EXT

1188: AND UAI.PROCESS_STATUS = G_PS_IN_PROCESS
1189: AND UAI.ATTR_GROUP_ID IS NOT NULL
1190: AND NOT EXISTS
1191: ( SELECT 'X'
1192: FROM EGO_FND_DSC_FLX_CTX_EXT FLX_EXT
1193: WHERE APPLICATION_ID = 431
1194: AND DESCRIPTIVE_FLEXFIELD_NAME = UAI.ATTR_GROUP_TYPE --l_attr_group_type
1195: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = UAI.ATTR_GROUP_INT_NAME
1196: AND ATTR_GROUP_ID = UAI.ATTR_GROUP_ID);

Line 1206: FROM EGO_FND_DSC_FLX_CTX_EXT FLX_EXT

1202: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Attr Group ID conversion', 0);
1203: END IF;
1204: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI
1205: SET ATTR_GROUP_ID = (SELECT ATTR_GROUP_ID
1206: FROM EGO_FND_DSC_FLX_CTX_EXT FLX_EXT
1207: WHERE APPLICATION_ID = 431
1208: AND DESCRIPTIVE_FLEXFIELD_NAME = UAI.ATTR_GROUP_TYPE --l_attr_group_type
1209: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = UAI.ATTR_GROUP_INT_NAME)
1210: WHERE UAI.DATA_SET_ID = p_data_set_id

Line 1610: EGO_FND_DSC_FLX_CTX_EXT ag_ext,

1606: AND PROCESS_STATUS = G_PS_IN_PROCESS
1607: AND ROW_IDENTIFIER IN (SELECT ROW_IDENTIFIER
1608: FROM
1609: EGO_ITM_USR_ATTR_INTRFC intf,
1610: EGO_FND_DSC_FLX_CTX_EXT ag_ext,
1611: MTL_SYSTEM_ITEMS_B msib
1612: WHERE intf.DATA_SET_ID = p_data_set_id
1613: AND intf.PROCESS_STATUS = G_PS_IN_PROCESS
1614: AND intf.ATTR_GROUP_ID = ag_ext.ATTR_GROUP_ID

Line 1817: FROM EGO_FND_DSC_FLX_CTX_EXT AG_EXT, MTL_SYSTEM_ITEMS_INTERFACE MSII

1813: SET PROCESS_STATUS = G_PS_STYLE_VARIANT_IN_PROCESS
1814: WHERE INTF.DATA_SET_ID = p_data_set_id
1815: AND INTF.PROCESS_STATUS = G_PS_IN_PROCESS
1816: AND EXISTS (SELECT NULL
1817: FROM EGO_FND_DSC_FLX_CTX_EXT AG_EXT, MTL_SYSTEM_ITEMS_INTERFACE MSII
1818: WHERE AG_EXT.VARIANT = 'Y'
1819: AND AG_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL(INTF.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
1820: AND AG_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = INTF.ATTR_GROUP_INT_NAME
1821: AND INTF.ORGANIZATION_ID = MSII.ORGANIZATION_ID

Line 1826: FROM EGO_FND_DSC_FLX_CTX_EXT AG_EXT1, MTL_SYSTEM_ITEMS_B MSIB

1822: AND MSII.STYLE_ITEM_FLAG = 'Y'
1823: AND INTF.INVENTORY_ITEM_ID = MSII.INVENTORY_ITEM_ID
1824: UNION ALL
1825: SELECT NULL
1826: FROM EGO_FND_DSC_FLX_CTX_EXT AG_EXT1, MTL_SYSTEM_ITEMS_B MSIB
1827: WHERE AG_EXT1.VARIANT = 'Y'
1828: AND AG_EXT1.DESCRIPTIVE_FLEXFIELD_NAME = NVL(INTF.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
1829: AND AG_EXT1.DESCRIPTIVE_FLEX_CONTEXT_CODE = INTF.ATTR_GROUP_INT_NAME
1830: AND INTF.ORGANIZATION_ID = MSIB.ORGANIZATION_ID

Line 2431: EGO_FND_DSC_FLX_CTX_EXT AG_EXT,

2427: WHERE DATA_SET_ID = p_data_set_id
2428: AND PROCESS_STATUS = G_PS_IN_PROCESS
2429: AND ROW_IDENTIFIER IN (SELECT ROW_IDENTIFIER
2430: FROM
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,

Line 3233: EGO_FND_DSC_FLX_CTX_EXT ag_ext

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
3236: AND ag_ext.DESCRIPTIVE_FLEX_CONTEXT_CODE = attr_ext.DESCRIPTIVE_FLEX_CONTEXT_CODE
3237: AND ag_ext.APPLICATION_ID = attr_ext.APPLICATION_ID

Line 3349: FROM (#' || p_source_entity_sql || q'#) src, EGO_FND_DSC_FLX_CTX_EXT ag_ext

3345: src.SOURCE_SYSTEM_REFERENCE,
3346: #'|| l_prog_int_char1_value|| q'# AS PROG_INT_CHAR1,
3347: #'|| l_prog_int_num4_value|| q'# AS PROG_INT_NUM4,
3348: src.BUNDLE_ID
3349: FROM (#' || p_source_entity_sql || q'#) src, EGO_FND_DSC_FLX_CTX_EXT ag_ext
3350: WHERE ag_ext.DESCRIPTIVE_FLEXFIELD_NAME = NVL(src.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
3351: AND ag_ext.DESCRIPTIVE_FLEX_CONTEXT_CODE = src.ATTR_GROUP_INT_NAME
3352: AND ag_ext.APPLICATION_ID = 431
3353: AND ( ag_ext.MULTI_ROW= 'N'

Line 3550: EGO_FND_DSC_FLX_CTX_EXT ag_ext #';

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'#
3554: AND src.ATTR_GROUP_ID = ag_ext.ATTR_GROUP_ID