APPS.EGO_IMPORT_UTIL_PVT dependencies on EGO_DATA_LEVEL_B

Line 86: FROM EGO_DATA_LEVEL_B edlb

82: -- Bug 13434831 : Start (Performance Change)
83: /*
84: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
85: SET uai.DATA_LEVEL_ID = (SELECT edlb.DATA_LEVEL_ID
86: FROM EGO_DATA_LEVEL_B edlb
87: WHERE edlb.DATA_LEVEL_NAME = uai.DATA_LEVEL_NAME
88: AND edlb.APPLICATION_ID = 431
89: AND edlb.ATTR_GROUP_TYPE = NVL(uai.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
90: )

Line 113: FROM EGO_DATA_LEVEL_B edlb

109:
110: -- Consolidating above two queries into single query as below.
111: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
112: SET uai.DATA_LEVEL_ID = Nvl ((SELECT edlb.DATA_LEVEL_ID
113: FROM EGO_DATA_LEVEL_B edlb
114: WHERE edlb.DATA_LEVEL_NAME = uai.DATA_LEVEL_NAME
115: AND edlb.APPLICATION_ID = 431
116: AND edlb.ATTR_GROUP_TYPE = NVL(uai.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
117: ),

Line 519: FROM EGO_DATA_LEVEL_B

515:
516: /* Bug 9201112. Fetching data for ITEM_ORG Data Level also. */
517: CURSOR c_data_levels IS
518: SELECT ATTR_GROUP_TYPE, DATA_LEVEL_ID, DATA_LEVEL_NAME
519: FROM EGO_DATA_LEVEL_B
520: WHERE ATTR_GROUP_TYPE IN ('EGO_ITEMMGMT_GROUP', 'EGO_ITEM_GTIN_ATTRS', 'EGO_ITEM_GTIN_MULTI_ATTRS')
521: AND APPLICATION_ID = 431
522: AND DATA_LEVEL_NAME IN ( 'ITEM_LEVEL', 'ITEM_REVISION_LEVEL', 'ITEM_ORG' );
523:

Line 890: EGO_DATA_LEVEL_B edlb,

886: edlb.DATA_LEVEL_ID,
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))

Line 904: FROM EGO_DATA_LEVEL_B

900: UNION
901: SELECT
902: DATA_LEVEL_ID,
903: DATA_LEVEL_NAME
904: FROM EGO_DATA_LEVEL_B
905: WHERE APPLICATION_ID = 431
906: AND ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP'
907: AND DATA_LEVEL_NAME = 'ITEM_REVISION_LEVEL';
908:

Line 1073: FROM EGO_DATA_LEVEL_B

1069:
1070:
1071: CURSOR c_data_levels IS
1072: SELECT ATTR_GROUP_TYPE, DATA_LEVEL_ID, DATA_LEVEL_NAME
1073: FROM EGO_DATA_LEVEL_B
1074: WHERE ATTR_GROUP_TYPE IN ('EGO_ITEMMGMT_GROUP', 'EGO_ITEM_GTIN_ATTRS', 'EGO_ITEM_GTIN_MULTI_ATTRS')
1075: AND APPLICATION_ID = 431
1076: AND DATA_LEVEL_NAME IN ( 'ITEM_LEVEL', 'ITEM_REVISION_LEVEL', 'ITEM_ORG' );
1077:

Line 2252: FROM EGO_DATA_LEVEL_B

2248: )
2249: IS
2250: CURSOR c_data_levels IS
2251: SELECT DATA_LEVEL_ID, DATA_LEVEL_NAME
2252: FROM EGO_DATA_LEVEL_B
2253: WHERE ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP'
2254: AND APPLICATION_ID = 431
2255: AND DATA_LEVEL_NAME IN ('ITEM_LEVEL', 'ITEM_ORG', 'ITEM_SUP', 'ITEM_SUP_SITE', 'ITEM_SUP_SITE_ORG', 'ITEM_REVISION_LEVEL');
2256:

Line 3161: FROM EGO_DATA_LEVEL_B

3157: )
3158: IS
3159: CURSOR c_data_levels IS
3160: SELECT DATA_LEVEL_ID, DATA_LEVEL_NAME
3161: FROM EGO_DATA_LEVEL_B
3162: WHERE ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP'
3163: AND APPLICATION_ID = 431
3164: AND DATA_LEVEL_NAME IN ('ITEM_LEVEL', 'ITEM_ORG', 'ITEM_SUP', 'ITEM_SUP_SITE', 'ITEM_SUP_SITE_ORG');
3165:

Line 3869: FROM EGO_DATA_LEVEL_B

3865: END IF;
3866:
3867: BEGIN
3868: SELECT DATA_LEVEL_ID INTO l_item_master_dl_id
3869: FROM EGO_DATA_LEVEL_B
3870: WHERE ATTR_GROUP_TYPE = 'EGO_MASTER_ITEMS'
3871: AND APPLICATION_ID = 431
3872: AND DATA_LEVEL_NAME = 'ITEM_ORG';
3873: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 6204: WHERE data_level_id IN (SELECT data_level_id FROM ego_data_level_b

6200: CURSOR c_valid_data_level
6201: IS
6202: SELECT 1
6203: FROM ego_attr_group_dl
6204: WHERE data_level_id IN (SELECT data_level_id FROM ego_data_level_b
6205: WHERE attr_group_type = p_attr_group_type
6206: AND data_level_name = p_data_level_name
6207: AND application_id = 431)
6208: AND attr_group_id IN (SELECT attr_group_id FROM ego_attr_groups_v

Line 6481: FROM EGO_DATA_LEVEL_B

6477: END IF;
6478:
6479: BEGIN
6480: SELECT DATA_LEVEL_ID INTO l_item_master_dl_id
6481: FROM EGO_DATA_LEVEL_B
6482: WHERE ATTR_GROUP_TYPE = 'EGO_MASTER_ITEMS'
6483: AND APPLICATION_ID = 431
6484: AND DATA_LEVEL_NAME = 'ITEM_ORG';
6485: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 6776: FROM EGO_DATA_LEVEL_B

6772: END IF;
6773:
6774: BEGIN
6775: SELECT DATA_LEVEL_ID INTO l_item_master_dl_id
6776: FROM EGO_DATA_LEVEL_B
6777: WHERE ATTR_GROUP_TYPE = 'EGO_MASTER_ITEMS'
6778: AND APPLICATION_ID = 431
6779: AND DATA_LEVEL_NAME = 'ITEM_ORG';
6780: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 6958: FROM EGO_DATA_LEVEL_B

6954:
6955: Debug_Conc_Log('Clean_Dirty_SKUs : Object_id='||l_item_object_id);
6956:
6957: SELECT DATA_LEVEL_ID INTO l_item_dl_id
6958: FROM EGO_DATA_LEVEL_B
6959: WHERE ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP'
6960: AND APPLICATION_ID = 431
6961: AND DATA_LEVEL_NAME = 'ITEM_LEVEL';
6962: