APPS.EGO_IMPORT_PVT dependencies on EGO_DATA_LEVEL_B

Line 988: FROM EGO_DATA_LEVEL_B

984: Debug_Conc_Log( l_proc_log_prefix || 'Entering' );
985: Debug_Conc_Log( l_proc_log_prefix || 'Batch ID: ' || p_batch_id );
986: BEGIN
987: SELECT DATA_LEVEL_ID INTO l_rev_dl_id
988: FROM EGO_DATA_LEVEL_B
989: WHERE ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP'
990: AND APPLICATION_ID = 431
991: AND DATA_LEVEL_NAME = 'ITEM_REVISION_LEVEL';
992: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 1280: FROM EGO_ATTR_GROUP_DL A, EGO_DATA_LEVEL_B DL

1276: AND FL_CTX_EXT.APPLICATION_ID = 431
1277: AND FL_CTX_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = EIUAI.ATTR_GROUP_INT_NAME
1278: AND FL_CTX_EXT.MULTI_ROW = 'N'
1279: AND EXISTS( SELECT NULL
1280: FROM EGO_ATTR_GROUP_DL A, EGO_DATA_LEVEL_B DL
1281: WHERE DL.APPLICATION_ID = 431
1282: AND DL.ATTR_GROUP_TYPE = FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME
1283: AND DL.DATA_LEVEL_NAME IN ( 'ITEM_LEVEL' , 'ITEM_ORG', 'ITEM_SUP', 'ITEM_SUP_SITE', 'ITEM_SUP_SITE_ORG' )
1284: AND DL.DATA_LEVEL_ID = DL.DATA_LEVEL_ID

Line 1359: FROM EGO_ATTR_GROUP_DL A, EGO_DATA_LEVEL_B DL

1355: AND FL_CTX_EXT.APPLICATION_ID = 431
1356: AND FL_CTX_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = EIUAI.ATTR_GROUP_INT_NAME
1357: AND FL_CTX_EXT.MULTI_ROW = 'N'
1358: AND EXISTS( SELECT NULL
1359: FROM EGO_ATTR_GROUP_DL A, EGO_DATA_LEVEL_B DL
1360: WHERE DL.APPLICATION_ID = 431
1361: AND DL.ATTR_GROUP_TYPE = FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME
1362: AND DL.DATA_LEVEL_NAME IN ( 'ITEM_LEVEL' , 'ITEM_ORG', 'ITEM_SUP', 'ITEM_SUP_SITE', 'ITEM_SUP_SITE_ORG' )
1363: AND DL.DATA_LEVEL_ID = DL.DATA_LEVEL_ID

Line 4315: FROM EGO_ATTR_GROUP_DL A, EGO_DATA_LEVEL_B DL

4311: AND FL_CTX_EXT.APPLICATION_ID = 431
4312: AND FL_CTX_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = EIUAI.ATTR_GROUP_INT_NAME
4313: AND FL_CTX_EXT.MULTI_ROW = 'N'
4314: AND EXISTS( SELECT NULL
4315: FROM EGO_ATTR_GROUP_DL A, EGO_DATA_LEVEL_B DL
4316: WHERE DL.APPLICATION_ID = 431
4317: AND DL.ATTR_GROUP_TYPE = FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME
4318: AND DL.DATA_LEVEL_NAME IN ( 'ITEM_LEVEL' , 'ITEM_ORG', 'ITEM_SUP', 'ITEM_SUP_SITE', 'ITEM_SUP_SITE_ORG' )
4319: AND DL.DATA_LEVEL_ID = DL.DATA_LEVEL_ID

Line 4666: FROM EGO_DATA_LEVEL_B

4662: Debug_Conc_Log( l_proc_log_prefix || 'Entering' );
4663: Debug_Conc_Log( l_proc_log_prefix || 'Batch ID: ' || p_batch_id );
4664: BEGIN
4665: SELECT DATA_LEVEL_ID INTO l_rev_dl_id
4666: FROM EGO_DATA_LEVEL_B
4667: WHERE ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP'
4668: AND APPLICATION_ID = 431
4669: AND DATA_LEVEL_NAME = 'ITEM_REVISION_LEVEL';
4670: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 6552: FROM EGO_DATA_LEVEL_B EDLB

6548: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - Resolving data_level_name' );
6549:
6550: UPDATE EGO_ITEM_ASSOCIATIONS_INTF EIAI
6551: SET DATA_LEVEL_ID = (SELECT DATA_LEVEL_ID
6552: FROM EGO_DATA_LEVEL_B EDLB
6553: WHERE EDLB.APPLICATION_ID = 431
6554: AND EDLB.ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP'
6555: AND EDLB.DATA_LEVEL_NAME = EIAI.DATA_LEVEL_NAME
6556: )

Line 6565: FROM EGO_DATA_LEVEL_B edlb

6561:
6562:
6563: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
6564: SET uai.DATA_LEVEL_ID = (SELECT edlb.DATA_LEVEL_ID
6565: FROM EGO_DATA_LEVEL_B edlb
6566: WHERE edlb.DATA_LEVEL_NAME = uai.DATA_LEVEL_NAME
6567: AND edlb.APPLICATION_ID = 431
6568: AND edlb.ATTR_GROUP_TYPE = NVL(uai.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
6569: )

Line 12759: FROM EGO_ITEM_ASSOCIATIONS_INTF eiai, EGO_DATA_LEVEL_B edlb

12755: THEN 1
12756: ELSE NULL
12757: END
12758: ) UPDATE_CNT
12759: FROM EGO_ITEM_ASSOCIATIONS_INTF eiai, EGO_DATA_LEVEL_B edlb
12760: WHERE eiai.BATCH_ID = p_set_process_id
12761: AND eiai.DATA_LEVEL_ID = edlb.DATA_LEVEL_ID
12762: AND EXISTS
12763: (