APPS.EGO_ITEM_USER_ATTRS_CP_PUB dependencies on EGO_FND_DSC_FLX_CTX_EXT

Line 1408: FROM EGO_FND_DSC_FLX_CTX_EXT

1404: -- Find the Attr Group Type for Attribute Name --
1405: ---------------------------------------------------------
1406: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI
1407: SET ATTR_GROUP_TYPE = NVL(ATTR_GROUP_TYPE,(SELECT DESCRIPTIVE_FLEXFIELD_NAME
1408: FROM EGO_FND_DSC_FLX_CTX_EXT
1409: WHERE APPLICATION_ID = 431
1410: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = UAI.ATTR_GROUP_INT_NAME
1411: AND ROWNUM = 1))
1412: ,PROCESS_STATUS = DECODE((SELECT COUNT(DESCRIPTIVE_FLEXFIELD_NAME)

Line 1413: FROM EGO_FND_DSC_FLX_CTX_EXT

1409: WHERE APPLICATION_ID = 431
1410: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = UAI.ATTR_GROUP_INT_NAME
1411: AND ROWNUM = 1))
1412: ,PROCESS_STATUS = DECODE((SELECT COUNT(DESCRIPTIVE_FLEXFIELD_NAME)
1413: FROM EGO_FND_DSC_FLX_CTX_EXT
1414: WHERE APPLICATION_ID = 431
1415: AND (UAI.ATTR_GROUP_TYPE IS NULL OR UAI.ATTR_GROUP_TYPE=DESCRIPTIVE_FLEXFIELD_NAME)
1416: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = UAI.ATTR_GROUP_INT_NAME),
1417: 1,PROCESS_STATUS

Line 1439: -- FROM EGO_FND_DSC_FLX_CTX_EXT FLX_EXT

1435: -- WHERE UAI.DATA_SET_ID = p_data_set_id
1436: -- AND UAI.PROCESS_STATUS = G_PS_IN_PROCESS
1437: -- AND UAI.ATTR_GROUP_ID IS NOT NULL
1438: -- AND UAI.ATTR_GROUP_ID <> ( SELECT ATTR_GROUP_ID
1439: -- FROM EGO_FND_DSC_FLX_CTX_EXT FLX_EXT
1440: -- WHERE APPLICATION_ID = 431
1441: -- AND DESCRIPTIVE_FLEXFIELD_NAME = l_attr_group_type
1442: -- AND DESCRIPTIVE_FLEX_CONTEXT_CODE = UAI.ATTR_GROUP_INT_NAME);
1443:

Line 1452: FROM EGO_FND_DSC_FLX_CTX_EXT FLX_EXT

1448: AND UAI.PROCESS_STATUS = G_PS_IN_PROCESS
1449: AND UAI.ATTR_GROUP_ID IS NOT NULL
1450: AND NOT EXISTS
1451: ( SELECT 'X'
1452: FROM EGO_FND_DSC_FLX_CTX_EXT FLX_EXT
1453: WHERE APPLICATION_ID = 431
1454: AND DESCRIPTIVE_FLEXFIELD_NAME = UAI.ATTR_GROUP_TYPE --l_attr_group_type
1455: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = UAI.ATTR_GROUP_INT_NAME
1456: AND ATTR_GROUP_ID = UAI.ATTR_GROUP_ID);

Line 1466: FROM EGO_FND_DSC_FLX_CTX_EXT FLX_EXT

1462: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Attr Group ID conversion', 0);
1463: END IF;
1464: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI
1465: SET ATTR_GROUP_ID = (SELECT ATTR_GROUP_ID
1466: FROM EGO_FND_DSC_FLX_CTX_EXT FLX_EXT
1467: WHERE APPLICATION_ID = 431
1468: AND DESCRIPTIVE_FLEXFIELD_NAME = UAI.ATTR_GROUP_TYPE --l_attr_group_type
1469: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = UAI.ATTR_GROUP_INT_NAME)
1470: WHERE UAI.DATA_SET_ID = p_data_set_id

Line 2040: EGO_FND_DSC_FLX_CTX_EXT ag_ext,

2036: AND PROCESS_STATUS = G_PS_IN_PROCESS
2037: AND ROW_IDENTIFIER IN (SELECT ROW_IDENTIFIER
2038: FROM
2039: EGO_ITM_USR_ATTR_INTRFC intf,
2040: EGO_FND_DSC_FLX_CTX_EXT ag_ext,
2041: MTL_SYSTEM_ITEMS_B msib
2042: WHERE intf.DATA_SET_ID = p_data_set_id
2043: AND intf.PROCESS_STATUS = G_PS_IN_PROCESS
2044: AND intf.ATTR_GROUP_ID = ag_ext.ATTR_GROUP_ID

Line 2249: FROM EGO_FND_DSC_FLX_CTX_EXT AG_EXT, MTL_SYSTEM_ITEMS_INTERFACE MSII

2245: SET PROCESS_STATUS = G_PS_STYLE_VARIANT_IN_PROCESS
2246: WHERE INTF.DATA_SET_ID = p_data_set_id
2247: AND INTF.PROCESS_STATUS = G_PS_IN_PROCESS
2248: AND EXISTS (SELECT NULL
2249: FROM EGO_FND_DSC_FLX_CTX_EXT AG_EXT, MTL_SYSTEM_ITEMS_INTERFACE MSII
2250: WHERE AG_EXT.VARIANT = 'Y'
2251: AND AG_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL(INTF.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
2252: AND AG_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = INTF.ATTR_GROUP_INT_NAME
2253: AND INTF.ORGANIZATION_ID = MSII.ORGANIZATION_ID

Line 2259: FROM EGO_FND_DSC_FLX_CTX_EXT AG_EXT1, MTL_SYSTEM_ITEMS_B MSIB

2255: AND INTF.INVENTORY_ITEM_ID = MSII.INVENTORY_ITEM_ID
2256: AND AG_EXT.APPLICATION_ID = 431 /* Bug 9678667 */
2257: UNION ALL
2258: SELECT NULL
2259: FROM EGO_FND_DSC_FLX_CTX_EXT AG_EXT1, MTL_SYSTEM_ITEMS_B MSIB
2260: WHERE AG_EXT1.VARIANT = 'Y'
2261: AND AG_EXT1.DESCRIPTIVE_FLEXFIELD_NAME = NVL(INTF.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
2262: AND AG_EXT1.DESCRIPTIVE_FLEX_CONTEXT_CODE = INTF.ATTR_GROUP_INT_NAME
2263: AND INTF.ORGANIZATION_ID = MSIB.ORGANIZATION_ID

Line 3083: EGO_FND_DSC_FLX_CTX_EXT AG_EXT,

3079: WHERE DATA_SET_ID = p_data_set_id
3080: AND PROCESS_STATUS = G_PS_IN_PROCESS
3081: AND ROW_IDENTIFIER IN (SELECT ROW_IDENTIFIER
3082: FROM
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,

Line 3981: EGO_FND_DSC_FLX_CTX_EXT ag_ext

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

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

4093: src.SOURCE_SYSTEM_REFERENCE,
4094: #'|| l_prog_int_char1_value|| q'# AS PROG_INT_CHAR1,
4095: #'|| l_prog_int_num4_value|| q'# AS PROG_INT_NUM4,
4096: src.BUNDLE_ID
4097: FROM (#' || p_source_entity_sql || q'#) src, EGO_FND_DSC_FLX_CTX_EXT ag_ext
4098: WHERE ag_ext.DESCRIPTIVE_FLEXFIELD_NAME = NVL(src.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
4099: AND ag_ext.DESCRIPTIVE_FLEX_CONTEXT_CODE = src.ATTR_GROUP_INT_NAME
4100: AND ag_ext.APPLICATION_ID = 431
4101: AND ( ag_ext.MULTI_ROW= 'N'

Line 4305: EGO_FND_DSC_FLX_CTX_EXT ag_ext #';

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