APPS.EGO_IMPORT_PVT dependencies on EGO_DATA_LEVEL_B

Line 1003: FROM EGO_DATA_LEVEL_B

999: Debug_Conc_Log( l_proc_log_prefix || 'Entering' );
1000: Debug_Conc_Log( l_proc_log_prefix || 'Batch ID: ' || p_batch_id );
1001: BEGIN
1002: SELECT DATA_LEVEL_ID INTO l_rev_dl_id
1003: FROM EGO_DATA_LEVEL_B
1004: WHERE ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP'
1005: AND APPLICATION_ID = 431
1006: AND DATA_LEVEL_NAME = 'ITEM_REVISION_LEVEL';
1007: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 1295: FROM EGO_ATTR_GROUP_DL A, EGO_DATA_LEVEL_B DL

1291: AND FL_CTX_EXT.APPLICATION_ID = 431
1292: AND FL_CTX_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = EIUAI.ATTR_GROUP_INT_NAME
1293: AND FL_CTX_EXT.MULTI_ROW = 'N'
1294: AND EXISTS( SELECT NULL
1295: FROM EGO_ATTR_GROUP_DL A, EGO_DATA_LEVEL_B DL
1296: WHERE DL.APPLICATION_ID = 431
1297: AND DL.ATTR_GROUP_TYPE = FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME
1298: AND DL.DATA_LEVEL_NAME IN ( 'ITEM_LEVEL' , 'ITEM_ORG', 'ITEM_SUP', 'ITEM_SUP_SITE', 'ITEM_SUP_SITE_ORG' )
1299: /* Bug:11887867

Line 1377: FROM EGO_ATTR_GROUP_DL A, EGO_DATA_LEVEL_B DL

1373: AND FL_CTX_EXT.APPLICATION_ID = 431
1374: AND FL_CTX_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = EIUAI.ATTR_GROUP_INT_NAME
1375: AND FL_CTX_EXT.MULTI_ROW = 'N'
1376: AND EXISTS( SELECT NULL
1377: FROM EGO_ATTR_GROUP_DL A, EGO_DATA_LEVEL_B DL
1378: WHERE DL.APPLICATION_ID = 431
1379: AND DL.ATTR_GROUP_TYPE = FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME
1380: AND DL.DATA_LEVEL_NAME IN ( 'ITEM_LEVEL' , 'ITEM_ORG', 'ITEM_SUP', 'ITEM_SUP_SITE', 'ITEM_SUP_SITE_ORG' )
1381: /* Bug:11887867

Line 4377: FROM EGO_ATTR_GROUP_DL A, EGO_DATA_LEVEL_B DL

4373: AND FL_CTX_EXT.APPLICATION_ID = 431
4374: AND FL_CTX_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = EIUAI.ATTR_GROUP_INT_NAME
4375: AND FL_CTX_EXT.MULTI_ROW = 'N'
4376: AND EXISTS( SELECT NULL
4377: FROM EGO_ATTR_GROUP_DL A, EGO_DATA_LEVEL_B DL
4378: WHERE DL.APPLICATION_ID = 431
4379: AND DL.ATTR_GROUP_TYPE = FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME
4380: AND DL.DATA_LEVEL_NAME IN ( 'ITEM_LEVEL' , 'ITEM_ORG', 'ITEM_SUP', 'ITEM_SUP_SITE', 'ITEM_SUP_SITE_ORG' )
4381: /* Bug:11887867

Line 4731: FROM EGO_DATA_LEVEL_B

4727: Debug_Conc_Log( l_proc_log_prefix || 'Entering' );
4728: Debug_Conc_Log( l_proc_log_prefix || 'Batch ID: ' || p_batch_id );
4729: BEGIN
4730: SELECT DATA_LEVEL_ID INTO l_rev_dl_id
4731: FROM EGO_DATA_LEVEL_B
4732: WHERE ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP'
4733: AND APPLICATION_ID = 431
4734: AND DATA_LEVEL_NAME = 'ITEM_REVISION_LEVEL';
4735: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 6634: FROM EGO_DATA_LEVEL_B EDLB

6630: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - Resolving data_level_name' );
6631:
6632: UPDATE EGO_ITEM_ASSOCIATIONS_INTF EIAI
6633: SET DATA_LEVEL_ID = (SELECT DATA_LEVEL_ID
6634: FROM EGO_DATA_LEVEL_B EDLB
6635: WHERE EDLB.APPLICATION_ID = 431
6636: AND EDLB.ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP'
6637: AND EDLB.DATA_LEVEL_NAME = EIAI.DATA_LEVEL_NAME
6638: )

Line 6647: FROM EGO_DATA_LEVEL_B edlb

6643:
6644:
6645: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
6646: SET uai.DATA_LEVEL_ID = (SELECT edlb.DATA_LEVEL_ID
6647: FROM EGO_DATA_LEVEL_B edlb
6648: WHERE edlb.DATA_LEVEL_NAME = uai.DATA_LEVEL_NAME
6649: AND edlb.APPLICATION_ID = 431
6650: AND edlb.ATTR_GROUP_TYPE = NVL(uai.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
6651: )

Line 12879: FROM EGO_ITEM_ASSOCIATIONS_INTF eiai, EGO_DATA_LEVEL_B edlb

12875: THEN 1
12876: ELSE NULL
12877: END
12878: ) UPDATE_CNT
12879: FROM EGO_ITEM_ASSOCIATIONS_INTF eiai, EGO_DATA_LEVEL_B edlb
12880: WHERE eiai.BATCH_ID = p_set_process_id
12881: AND eiai.DATA_LEVEL_ID = edlb.DATA_LEVEL_ID
12882: AND EXISTS
12883: (