APPS.EGO_IMPORT_UTIL_PVT dependencies on EGO_FND_DSC_FLX_CTX_EXT

Line 114: FROM EGO_ATTR_GROUP_DL eagd, EGO_FND_DSC_FLX_CTX_EXT ag_ext

110: -- put that data level id here. --
111: -----------------------------------------------------------
112: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
113: SET DATA_LEVEL_ID = (SELECT DATA_LEVEL_ID
114: FROM EGO_ATTR_GROUP_DL eagd, EGO_FND_DSC_FLX_CTX_EXT ag_ext
115: WHERE eagd.ATTR_GROUP_ID = ag_ext.ATTR_GROUP_ID
116: AND ag_ext.APPLICATION_ID = 431
117: AND ag_ext.DESCRIPTIVE_FLEXFIELD_NAME = NVL(uai.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
118: AND ag_ext.DESCRIPTIVE_FLEX_CONTEXT_CODE = uai.ATTR_GROUP_INT_NAME

Line 126: FROM EGO_ATTR_GROUP_DL eagd, EGO_FND_DSC_FLX_CTX_EXT ag_ext

122: AND uai.DATA_LEVEL_ID IS NULL
123: AND uai.DATA_LEVEL_NAME IS NULL
124: AND uai.USER_DATA_LEVEL_NAME IS NULL
125: AND (SELECT COUNT(*)
126: FROM EGO_ATTR_GROUP_DL eagd, EGO_FND_DSC_FLX_CTX_EXT ag_ext
127: WHERE eagd.ATTR_GROUP_ID = ag_ext.ATTR_GROUP_ID
128: AND ag_ext.APPLICATION_ID = 431
129: AND ag_ext.DESCRIPTIVE_FLEXFIELD_NAME = NVL(uai.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
130: AND ag_ext.DESCRIPTIVE_FLEX_CONTEXT_CODE = uai.ATTR_GROUP_INT_NAME

Line 191: FROM EGO_FND_DSC_FLX_CTX_EXT FLX_EXT

187: Debug_Conc_Log('Resolve_PKs_For_Child: Updated Categories '||SQL%ROWCOUNT);
188:
189: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI
190: SET ATTR_GROUP_ID = (SELECT ATTR_GROUP_ID
191: FROM EGO_FND_DSC_FLX_CTX_EXT FLX_EXT
192: WHERE APPLICATION_ID = 431
193: AND DESCRIPTIVE_FLEXFIELD_NAME = UAI.ATTR_GROUP_TYPE
194: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = UAI.ATTR_GROUP_INT_NAME)
195: WHERE UAI.DATA_SET_ID = p_batch_id

Line 790: EGO_FND_DSC_FLX_CTX_EXT ag_ext

786: edlb.DATA_LEVEL_NAME
787: FROM
788: EGO_IMPORT_COPY_OPTIONS eico,
789: EGO_DATA_LEVEL_B edlb,
790: EGO_FND_DSC_FLX_CTX_EXT ag_ext
791: WHERE eico.COPY_OPTION LIKE 'COPY_ATTR_GROUP%'
792: AND eico.BATCH_ID = p_batch_id
793: AND edlb.DATA_LEVEL_NAME = RTRIM(SUBSTR(eico.COPY_OPTION, INSTR(eico.COPY_OPTION, ':')+1))
794: AND edlb.APPLICATION_ID = 431

Line 2480: FROM EGO_FND_DSC_FLX_CTX_EXT fl_ctx

2476: AND eagd.DATA_LEVEL_ID = ext_prod.DATA_LEVEL_ID
2477: AND ( NVL(eagd.DEFAULTING, 'D') = 'D' OR msii.STYLE_ITEM_ID IS NULL )
2478: )
2479: AND NOT EXISTS (SELECT 1
2480: FROM EGO_FND_DSC_FLX_CTX_EXT fl_ctx
2481: WHERE fl_ctx.DESCRIPTIVE_FLEXFIELD_NAME = 'EGO_ITEMMGMT_GROUP'
2482: AND fl_ctx.DESCRIPTIVE_FLEX_CONTEXT_CODE IN ('ItemDetailImage', 'ItemDetailDesc')
2483: AND ext_prod.ATTR_GROUP_ID = fl_ctx.ATTR_GROUP_ID
2484: )#';

Line 2507: FROM EGO_FND_DSC_FLX_CTX_EXT fl_ctx

2503: AND eagd.DATA_LEVEL_ID = ext_prod.DATA_LEVEL_ID
2504: AND ( NVL(eagd.DEFAULTING, 'D') = 'D' OR msii.STYLE_ITEM_ID IS NULL )
2505: )
2506: AND NOT EXISTS (SELECT 1
2507: FROM EGO_FND_DSC_FLX_CTX_EXT fl_ctx
2508: WHERE fl_ctx.DESCRIPTIVE_FLEXFIELD_NAME = 'EGO_ITEMMGMT_GROUP'
2509: AND fl_ctx.DESCRIPTIVE_FLEX_CONTEXT_CODE IN ('ItemDetailImage', 'ItemDetailDesc')
2510: AND ext_prod.ATTR_GROUP_ID = fl_ctx.ATTR_GROUP_ID
2511: )#';

Line 3044: EGO_FND_DSC_FLX_CTX_EXT ag_ext

3040: FROM
3041: MTL_SYSTEM_ITEMS_INTERFACE msii,
3042: EGO_ITM_USR_ATTR_INTRFC ext_intf,
3043: MTL_PARAMETERS mp,
3044: EGO_FND_DSC_FLX_CTX_EXT ag_ext
3045: WHERE msii.SET_PROCESS_ID = #' || p_batch_id || q'#
3046: AND msii.PROCESS_FLAG = 1
3047: AND msii.TRANSACTION_TYPE = 'CREATE'
3048: AND msii.STYLE_ITEM_ID IS NULL

Line 3133: EGO_FND_DSC_FLX_CTX_EXT ag_ext

3129: eiai.DATA_LEVEL_ID
3130: FROM
3131: EGO_ITEM_ASSOCIATIONS_INTF eiai,
3132: EGO_ITM_USR_ATTR_INTRFC ext_intf,
3133: EGO_FND_DSC_FLX_CTX_EXT ag_ext
3134: WHERE eiai.BATCH_ID = #' || p_batch_id || q'#
3135: AND eiai.TRANSACTION_TYPE = 'CREATE'
3136: AND eiai.DATA_LEVEL_ID = #' || l_item_sup_dl_id || q'#
3137: AND eiai.PROCESS_FLAG = 1

Line 3230: EGO_FND_DSC_FLX_CTX_EXT ag_ext

3226: eiai.DATA_LEVEL_ID
3227: FROM
3228: EGO_ITEM_ASSOCIATIONS_INTF eiai,
3229: EGO_ITM_USR_ATTR_INTRFC ext_intf,
3230: EGO_FND_DSC_FLX_CTX_EXT ag_ext
3231: WHERE eiai.BATCH_ID = #' || p_batch_id || q'#
3232: AND eiai.TRANSACTION_TYPE = 'CREATE'
3233: AND eiai.DATA_LEVEL_ID = #' || l_item_sup_site_dl_id || q'#
3234: AND eiai.PROCESS_FLAG = 1

Line 3331: EGO_FND_DSC_FLX_CTX_EXT ag_ext

3327: FROM
3328: EGO_ITEM_ASSOCIATIONS_INTF eiai,
3329: EGO_ITM_USR_ATTR_INTRFC ext_intf,
3330: MTL_PARAMETERS mp,
3331: EGO_FND_DSC_FLX_CTX_EXT ag_ext
3332: WHERE eiai.BATCH_ID = #' || p_batch_id || q'#
3333: AND eiai.TRANSACTION_TYPE = 'CREATE'
3334: AND eiai.DATA_LEVEL_ID = #' || l_item_sup_site_org_dl_id || q'#
3335: AND eiai.PROCESS_FLAG = 1

Line 6184: EGO_FND_DSC_FLX_CTX_EXT ag_ext,

6180:
6181: DELETE FROM EGO_SKU_VARIANT_ATTR_USAGES esvas
6182: WHERE EXISTS (SELECT NULL
6183: FROM
6184: EGO_FND_DSC_FLX_CTX_EXT ag_ext,
6185: EGO_OBJ_AG_ASSOCS_B assoc,
6186: MTL_SYSTEM_ITEMS_INTERFACE msii
6187: WHERE msii.INVENTORY_ITEM_ID = esvas.SKU_ITEM_ID
6188: AND msii.ORGANIZATION_ID = esvas.ORGANIZATION_ID