APPS.EGO_IMPORT_UTIL_PVT dependencies on EGO_DATA_LEVEL_B

Line 84: FROM EGO_DATA_LEVEL_B edlb

80: IS
81: BEGIN
82: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
83: SET uai.DATA_LEVEL_ID = (SELECT edlb.DATA_LEVEL_ID
84: FROM EGO_DATA_LEVEL_B edlb
85: WHERE edlb.DATA_LEVEL_NAME = uai.DATA_LEVEL_NAME
86: AND edlb.APPLICATION_ID = 431
87: AND edlb.ATTR_GROUP_TYPE = NVL(uai.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
88: )

Line 466: FROM EGO_DATA_LEVEL_B

462: l_item_gtin_multi_dl_id NUMBER;
463:
464: CURSOR c_data_levels IS
465: SELECT ATTR_GROUP_TYPE, DATA_LEVEL_ID, DATA_LEVEL_NAME
466: FROM EGO_DATA_LEVEL_B
467: WHERE ATTR_GROUP_TYPE IN ('EGO_ITEMMGMT_GROUP', 'EGO_ITEM_GTIN_ATTRS', 'EGO_ITEM_GTIN_MULTI_ATTRS')
468: AND APPLICATION_ID = 431
469: AND DATA_LEVEL_NAME IN ( 'ITEM_LEVEL', 'ITEM_REVISION_LEVEL' );
470:

Line 789: EGO_DATA_LEVEL_B edlb,

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

Line 803: FROM EGO_DATA_LEVEL_B

799: UNION
800: SELECT
801: DATA_LEVEL_ID,
802: DATA_LEVEL_NAME
803: FROM EGO_DATA_LEVEL_B
804: WHERE APPLICATION_ID = 431
805: AND ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP'
806: AND DATA_LEVEL_NAME = 'ITEM_REVISION_LEVEL';
807:

Line 965: FROM EGO_DATA_LEVEL_B

961: l_exclude_ag_sql VARCHAR2(4000);
962:
963: CURSOR c_data_levels IS
964: SELECT ATTR_GROUP_TYPE, DATA_LEVEL_ID, DATA_LEVEL_NAME
965: FROM EGO_DATA_LEVEL_B
966: WHERE ATTR_GROUP_TYPE IN ('EGO_ITEMMGMT_GROUP', 'EGO_ITEM_GTIN_ATTRS', 'EGO_ITEM_GTIN_MULTI_ATTRS')
967: AND APPLICATION_ID = 431
968: AND DATA_LEVEL_NAME IN ( 'ITEM_LEVEL', 'ITEM_REVISION_LEVEL', 'ITEM_ORG' );
969:

Line 2079: FROM EGO_DATA_LEVEL_B

2075: )
2076: IS
2077: CURSOR c_data_levels IS
2078: SELECT DATA_LEVEL_ID, DATA_LEVEL_NAME
2079: FROM EGO_DATA_LEVEL_B
2080: WHERE ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP'
2081: AND APPLICATION_ID = 431
2082: AND DATA_LEVEL_NAME IN ('ITEM_LEVEL', 'ITEM_ORG', 'ITEM_SUP', 'ITEM_SUP_SITE', 'ITEM_SUP_SITE_ORG', 'ITEM_REVISION_LEVEL');
2083:

Line 2972: FROM EGO_DATA_LEVEL_B

2968: )
2969: IS
2970: CURSOR c_data_levels IS
2971: SELECT DATA_LEVEL_ID, DATA_LEVEL_NAME
2972: FROM EGO_DATA_LEVEL_B
2973: WHERE ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP'
2974: AND APPLICATION_ID = 431
2975: AND DATA_LEVEL_NAME IN ('ITEM_LEVEL', 'ITEM_ORG', 'ITEM_SUP', 'ITEM_SUP_SITE', 'ITEM_SUP_SITE_ORG');
2976:

Line 3666: FROM EGO_DATA_LEVEL_B

3662: END IF;
3663:
3664: BEGIN
3665: SELECT DATA_LEVEL_ID INTO l_item_master_dl_id
3666: FROM EGO_DATA_LEVEL_B
3667: WHERE ATTR_GROUP_TYPE = 'EGO_MASTER_ITEMS'
3668: AND APPLICATION_ID = 431
3669: AND DATA_LEVEL_NAME = 'ITEM_ORG';
3670: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 5420: WHERE data_level_id IN (SELECT data_level_id FROM ego_data_level_b

5416: CURSOR c_valid_data_level
5417: IS
5418: SELECT 1
5419: FROM ego_attr_group_dl
5420: WHERE data_level_id IN (SELECT data_level_id FROM ego_data_level_b
5421: WHERE attr_group_type = p_attr_group_type
5422: AND data_level_name = p_data_level_name
5423: AND application_id = 431)
5424: AND attr_group_id IN (SELECT attr_group_id FROM ego_attr_groups_v

Line 5697: FROM EGO_DATA_LEVEL_B

5693: END IF;
5694:
5695: BEGIN
5696: SELECT DATA_LEVEL_ID INTO l_item_master_dl_id
5697: FROM EGO_DATA_LEVEL_B
5698: WHERE ATTR_GROUP_TYPE = 'EGO_MASTER_ITEMS'
5699: AND APPLICATION_ID = 431
5700: AND DATA_LEVEL_NAME = 'ITEM_ORG';
5701: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 5992: FROM EGO_DATA_LEVEL_B

5988: END IF;
5989:
5990: BEGIN
5991: SELECT DATA_LEVEL_ID INTO l_item_master_dl_id
5992: FROM EGO_DATA_LEVEL_B
5993: WHERE ATTR_GROUP_TYPE = 'EGO_MASTER_ITEMS'
5994: AND APPLICATION_ID = 431
5995: AND DATA_LEVEL_NAME = 'ITEM_ORG';
5996: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 6174: FROM EGO_DATA_LEVEL_B

6170:
6171: Debug_Conc_Log('Clean_Dirty_SKUs : Object_id='||l_item_object_id);
6172:
6173: SELECT DATA_LEVEL_ID INTO l_item_dl_id
6174: FROM EGO_DATA_LEVEL_B
6175: WHERE ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP'
6176: AND APPLICATION_ID = 431
6177: AND DATA_LEVEL_NAME = 'ITEM_LEVEL';
6178: