DBA Data[Home] [Help]

APPS.EGO_ITEM_BULKLOAD_PKG dependencies on EGO_DATA_LEVEL_B

Line 7259: FROM EGO_DATA_LEVEL_B

7255: SELECT attribute_code, intf_column_name, data_level_id
7256: FROM ego_results_fmt_usages
7257: WHERE resultfmt_usage_id = c_resultfmt_usage_id
7258: /* AND DATA_LEVEL_ID in (SELECT DATA_LEVEL_ID
7259: FROM EGO_DATA_LEVEL_B
7260: WHERE DATA_LEVEL_NAME IN ('ITEM_SUP','ITEM_ORG','ITEM_SUP_SITE')
7261: AND APPLICATION_ID = 431
7262: AND ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP'
7263: )*/;

Line 7447: FROM EGO_DATA_LEVEL_B

7443: l_supplier_number_col IS NOT NULL) THEN
7444:
7445: SELECT DATA_LEVEL_ID
7446: INTO l_data_level_id
7447: FROM EGO_DATA_LEVEL_B
7448: WHERE DATA_LEVEL_NAME = 'ITEM_SUP'
7449: AND APPLICATION_ID = 431
7450: AND ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP';
7451:

Line 7566: FROM EGO_DATA_LEVEL_B

7562: AND l_supplier_site_name_col IS NOT NULL) THEN
7563:
7564: SELECT DATA_LEVEL_ID
7565: INTO l_data_level_id
7566: FROM EGO_DATA_LEVEL_B
7567: WHERE DATA_LEVEL_NAME = 'ITEM_SUP_SITE'
7568: AND APPLICATION_ID = 431
7569: AND ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP';
7570:

Line 7573: FROM EGO_DATA_LEVEL_B

7569: AND ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP';
7570:
7571: SELECT DATA_LEVEL_ID
7572: INTO l_data_level_id_1
7573: FROM EGO_DATA_LEVEL_B
7574: WHERE DATA_LEVEL_NAME = 'ITEM_SUP_SITE_ORG'
7575: AND APPLICATION_ID = 431
7576: AND ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP';
7577: