APPS.EGO_IMPORT_UTIL_PVT dependencies on EGO_FND_DSC_FLX_CTX_EXT

Line 137: FROM EGO_ATTR_GROUP_DL eagd, EGO_FND_DSC_FLX_CTX_EXT ag_ext

133: -- put that data level id here. --
134: -----------------------------------------------------------
135: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
136: SET DATA_LEVEL_ID = (SELECT DATA_LEVEL_ID
137: FROM EGO_ATTR_GROUP_DL eagd, EGO_FND_DSC_FLX_CTX_EXT ag_ext
138: WHERE eagd.ATTR_GROUP_ID = ag_ext.ATTR_GROUP_ID
139: AND ag_ext.APPLICATION_ID = 431
140: AND ag_ext.DESCRIPTIVE_FLEXFIELD_NAME = NVL(uai.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
141: AND ag_ext.DESCRIPTIVE_FLEX_CONTEXT_CODE = uai.ATTR_GROUP_INT_NAME

Line 149: FROM EGO_ATTR_GROUP_DL eagd, EGO_FND_DSC_FLX_CTX_EXT ag_ext

145: AND uai.DATA_LEVEL_ID IS NULL
146: AND uai.DATA_LEVEL_NAME IS NULL
147: AND uai.USER_DATA_LEVEL_NAME IS NULL
148: AND (SELECT COUNT(*)
149: FROM EGO_ATTR_GROUP_DL eagd, EGO_FND_DSC_FLX_CTX_EXT ag_ext
150: WHERE eagd.ATTR_GROUP_ID = ag_ext.ATTR_GROUP_ID
151: AND ag_ext.APPLICATION_ID = 431
152: AND ag_ext.DESCRIPTIVE_FLEXFIELD_NAME = NVL(uai.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
153: AND ag_ext.DESCRIPTIVE_FLEX_CONTEXT_CODE = uai.ATTR_GROUP_INT_NAME

Line 218: FROM EGO_FND_DSC_FLX_CTX_EXT FLX_EXT

214: In between we are not depending on ATTR_GROUP_ID. */
215: /*
216: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI
217: SET ATTR_GROUP_ID = (SELECT ATTR_GROUP_ID
218: FROM EGO_FND_DSC_FLX_CTX_EXT FLX_EXT
219: WHERE APPLICATION_ID = 431
220: AND DESCRIPTIVE_FLEXFIELD_NAME = UAI.ATTR_GROUP_TYPE
221: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = UAI.ATTR_GROUP_INT_NAME)
222: WHERE UAI.DATA_SET_ID = p_batch_id

Line 891: EGO_FND_DSC_FLX_CTX_EXT ag_ext

887: edlb.DATA_LEVEL_NAME
888: FROM
889: EGO_IMPORT_COPY_OPTIONS eico,
890: EGO_DATA_LEVEL_B edlb,
891: EGO_FND_DSC_FLX_CTX_EXT ag_ext
892: WHERE eico.COPY_OPTION LIKE 'COPY_ATTR_GROUP%'
893: AND eico.BATCH_ID = p_batch_id
894: AND edlb.DATA_LEVEL_NAME = RTRIM(SUBSTR(eico.COPY_OPTION, INSTR(eico.COPY_OPTION, ':')+1))
895: AND edlb.APPLICATION_ID = 431

Line 1232: AND (SELECT VARIANT FROM EGO_FND_DSC_FLX_CTX_EXT EXT

1228: WHERE EIUAI.DATA_SET_ID = p_batch_id
1229: AND EIUAI.PROCESS_STATUS = l_g_ps_in_process
1230: AND EIUAI.ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP'
1231: AND EIUAI.PROG_INT_CHAR1 = 'EXT_DEFAULT_VAL_ROW'
1232: AND (SELECT VARIANT FROM EGO_FND_DSC_FLX_CTX_EXT EXT
1233: WHERE APPLICATION_ID = 431
1234: AND EIUAI.ATTR_GROUP_INT_NAME = DESCRIPTIVE_FLEX_CONTEXT_CODE
1235: AND DESCRIPTIVE_FLEXFIELD_NAME = 'EGO_ITEMMGMT_GROUP') = 'Y'
1236: AND EXISTS (SELECT 1 FROM MTL_SYSTEM_ITEMS_INTERFACE MSII

Line 2669: FROM EGO_FND_DSC_FLX_CTX_EXT fl_ctx

2665: AND eagd.DATA_LEVEL_ID = ext_prod.DATA_LEVEL_ID
2666: AND ( NVL(eagd.DEFAULTING, 'D') = 'D' OR msii.STYLE_ITEM_ID IS NULL )
2667: )
2668: AND NOT EXISTS (SELECT 1
2669: FROM EGO_FND_DSC_FLX_CTX_EXT fl_ctx
2670: WHERE fl_ctx.DESCRIPTIVE_FLEXFIELD_NAME = 'EGO_ITEMMGMT_GROUP'
2671: AND fl_ctx.DESCRIPTIVE_FLEX_CONTEXT_CODE IN ('ItemDetailImage', 'ItemDetailDesc')
2672: AND ext_prod.ATTR_GROUP_ID = fl_ctx.ATTR_GROUP_ID
2673: )#';

Line 2696: FROM EGO_FND_DSC_FLX_CTX_EXT fl_ctx

2692: AND eagd.DATA_LEVEL_ID = ext_prod.DATA_LEVEL_ID
2693: AND ( NVL(eagd.DEFAULTING, 'D') = 'D' OR msii.STYLE_ITEM_ID IS NULL )
2694: )
2695: AND NOT EXISTS (SELECT 1
2696: FROM EGO_FND_DSC_FLX_CTX_EXT fl_ctx
2697: WHERE fl_ctx.DESCRIPTIVE_FLEXFIELD_NAME = 'EGO_ITEMMGMT_GROUP'
2698: AND fl_ctx.DESCRIPTIVE_FLEX_CONTEXT_CODE IN ('ItemDetailImage', 'ItemDetailDesc')
2699: AND ext_prod.ATTR_GROUP_ID = fl_ctx.ATTR_GROUP_ID
2700: )#';

Line 3234: EGO_FND_DSC_FLX_CTX_EXT ag_ext

3230: FROM
3231: MTL_SYSTEM_ITEMS_INTERFACE msii,
3232: EGO_ITM_USR_ATTR_INTRFC ext_intf,
3233: MTL_PARAMETERS mp,
3234: EGO_FND_DSC_FLX_CTX_EXT ag_ext
3235: WHERE msii.SET_PROCESS_ID = #' || p_batch_id || q'#
3236: AND msii.PROCESS_FLAG = 1
3237: AND msii.TRANSACTION_TYPE = 'CREATE'
3238: AND msii.STYLE_ITEM_ID IS NULL

Line 3323: EGO_FND_DSC_FLX_CTX_EXT ag_ext

3319: eiai.DATA_LEVEL_ID
3320: FROM
3321: EGO_ITEM_ASSOCIATIONS_INTF eiai,
3322: EGO_ITM_USR_ATTR_INTRFC ext_intf,
3323: EGO_FND_DSC_FLX_CTX_EXT ag_ext
3324: WHERE eiai.BATCH_ID = #' || p_batch_id || q'#
3325: AND eiai.TRANSACTION_TYPE = 'CREATE'
3326: AND eiai.DATA_LEVEL_ID = #' || l_item_sup_dl_id || q'#
3327: AND eiai.PROCESS_FLAG = 1

Line 3420: EGO_FND_DSC_FLX_CTX_EXT ag_ext

3416: eiai.DATA_LEVEL_ID
3417: FROM
3418: EGO_ITEM_ASSOCIATIONS_INTF eiai,
3419: EGO_ITM_USR_ATTR_INTRFC ext_intf,
3420: EGO_FND_DSC_FLX_CTX_EXT ag_ext
3421: WHERE eiai.BATCH_ID = #' || p_batch_id || q'#
3422: AND eiai.TRANSACTION_TYPE = 'CREATE'
3423: AND eiai.DATA_LEVEL_ID = #' || l_item_sup_site_dl_id || q'#
3424: AND eiai.PROCESS_FLAG = 1

Line 3521: EGO_FND_DSC_FLX_CTX_EXT ag_ext

3517: FROM
3518: EGO_ITEM_ASSOCIATIONS_INTF eiai,
3519: EGO_ITM_USR_ATTR_INTRFC ext_intf,
3520: MTL_PARAMETERS mp,
3521: EGO_FND_DSC_FLX_CTX_EXT ag_ext
3522: WHERE eiai.BATCH_ID = #' || p_batch_id || q'#
3523: AND eiai.TRANSACTION_TYPE = 'CREATE'
3524: AND eiai.DATA_LEVEL_ID = #' || l_item_sup_site_org_dl_id || q'#
3525: AND eiai.PROCESS_FLAG = 1

Line 4236: ego_fnd_dsc_flx_ctx_ext ag_ext,

4232: l_n_def_value,l_c_def_value,l_d_def_value
4233: FROM ego_mappings_b MAP,
4234: fnd_descr_flex_column_usages fl_col,
4235: ego_fnd_df_col_usgs_ext attr_ext,
4236: ego_fnd_dsc_flx_ctx_ext ag_ext,
4237: ego_attr_group_dl ag_dl
4238: WHERE MAP.mapped_obj_type = 'A'
4239: AND fl_col.application_id = MAP.mapped_to_group_pk1
4240: AND fl_col.descriptive_flexfield_name = MAP.mapped_to_group_pk2

Line 6968: EGO_FND_DSC_FLX_CTX_EXT ag_ext,

6964:
6965: DELETE FROM EGO_SKU_VARIANT_ATTR_USAGES esvas
6966: WHERE EXISTS (SELECT NULL
6967: FROM
6968: EGO_FND_DSC_FLX_CTX_EXT ag_ext,
6969: EGO_OBJ_AG_ASSOCS_B assoc,
6970: MTL_SYSTEM_ITEMS_INTERFACE msii
6971: WHERE msii.INVENTORY_ITEM_ID = esvas.SKU_ITEM_ID
6972: AND msii.STYLE_ITEM_ID = esvas.STYLE_ITEM_ID