DBA Data[Home] [Help]

APPS.EGO_ITEM_BULKLOAD_PKG dependencies on EGO_DATA_LEVEL_B

Line 7412: FROM EGO_DATA_LEVEL_B

7408: SELECT attribute_code, intf_column_name, data_level_id
7409: FROM ego_results_fmt_usages
7410: WHERE resultfmt_usage_id = c_resultfmt_usage_id
7411: /* AND DATA_LEVEL_ID in (SELECT DATA_LEVEL_ID
7412: FROM EGO_DATA_LEVEL_B
7413: WHERE DATA_LEVEL_NAME IN ('ITEM_SUP','ITEM_ORG','ITEM_SUP_SITE')
7414: AND APPLICATION_ID = 431
7415: AND ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP'
7416: )*/;

Line 7600: FROM EGO_DATA_LEVEL_B

7596: l_supplier_number_col IS NOT NULL) THEN
7597:
7598: SELECT DATA_LEVEL_ID
7599: INTO l_data_level_id
7600: FROM EGO_DATA_LEVEL_B
7601: WHERE DATA_LEVEL_NAME = 'ITEM_SUP'
7602: AND APPLICATION_ID = 431
7603: AND ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP';
7604:

Line 7719: FROM EGO_DATA_LEVEL_B

7715: AND l_supplier_site_name_col IS NOT NULL) THEN
7716:
7717: SELECT DATA_LEVEL_ID
7718: INTO l_data_level_id
7719: FROM EGO_DATA_LEVEL_B
7720: WHERE DATA_LEVEL_NAME = 'ITEM_SUP_SITE'
7721: AND APPLICATION_ID = 431
7722: AND ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP';
7723:

Line 7726: FROM EGO_DATA_LEVEL_B

7722: AND ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP';
7723:
7724: SELECT DATA_LEVEL_ID
7725: INTO l_data_level_id_1
7726: FROM EGO_DATA_LEVEL_B
7727: WHERE DATA_LEVEL_NAME = 'ITEM_SUP_SITE_ORG'
7728: AND APPLICATION_ID = 431
7729: AND ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP';
7730: