APPS.OPI_EDW_INV_DAILY_STAT_F_C dependencies on EDW_UTIL

Line 50: EDW_UTIL.get_edw_base_uom(BASE_UOM,INVENTORY_ITEM_ID) EDW_BASE_UOM,

46: currency_conv_rate_not_exist EXCEPTION;
47:
48: CURSOR get_uom_data_cursor IS
49: select BASE_UOM, INVENTORY_ITEM_ID,
50: EDW_UTIL.get_edw_base_uom(BASE_UOM,INVENTORY_ITEM_ID) EDW_BASE_UOM,
51: EDW_UTIL.get_uom_conv_rate(BASE_UOM,INVENTORY_ITEM_ID) EDW_Uom_Conv_Rate
52: from
53: opi_ids_push_log
54: where

Line 51: EDW_UTIL.get_uom_conv_rate(BASE_UOM,INVENTORY_ITEM_ID) EDW_Uom_Conv_Rate

47:
48: CURSOR get_uom_data_cursor IS
49: select BASE_UOM, INVENTORY_ITEM_ID,
50: EDW_UTIL.get_edw_base_uom(BASE_UOM,INVENTORY_ITEM_ID) EDW_BASE_UOM,
51: EDW_UTIL.get_uom_conv_rate(BASE_UOM,INVENTORY_ITEM_ID) EDW_Uom_Conv_Rate
52: from
53: opi_ids_push_log
54: where
55: base_uom is not null and

Line 165: SELECT edw_util.get_base_currency(l_org_date.organization_id)

161:
162:
163:
164: IF l_org_date_csr%rowcount = 1 THEN
165: SELECT edw_util.get_base_currency(l_org_date.organization_id)
166: INTO l_base_currency_code
167: FROM dual;
168:
169: l_prev_org_id := l_org_date.organization_id;

Line 175: SELECT edw_util.get_base_currency(l_org_date.organization_id)

171: --dbms_output.put_line(' in l_org_date, ' || l_org_date.organization_id || l_org_date.trx_date );
172: END IF;
173:
174: IF l_prev_org_id <> l_org_date.organization_id THEN
175: SELECT edw_util.get_base_currency(l_org_date.organization_id)
176: INTO l_base_currency_code
177: FROM dual;
178:
179: l_prev_org_id := l_org_date.organization_id;