APPS.OPI_EDW_INV_DAILY_STAT_F_C dependencies on OPI_IDS_PUSH_LOG

Line 41: FROM opi_ids_push_log

37: l_global_conv_rate_flag BOOLEAN ;
38:
39: CURSOR l_org_date_csr IS
40: SELECT organization_id, trx_date
41: FROM opi_ids_push_log
42: WHERE push_flag = 1
43: GROUP BY organization_id, trx_date;
44:
45: currency_not_exist EXCEPTION;

Line 53: opi_ids_push_log

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
56: push_flag = 1
57: group by

Line 127: -- in the opi_ids_push_log.

123:
124: -- --------------------------------------------------------
125: -- call opi_extract_ids: This program will process the WIP and INV
126: -- Transactions by organization. It will then insert/update the records
127: -- in the opi_ids_push_log.
128: --
129: -- --------------------------------------------------------
130: --dbms_output.put_line(' ');
131: --dbms_output.put_line('call opi_extract_ids ');

Line 142: from opi_ids_push_log

138:
139:
140: --dbms_output.put_line('after extract ids ' || to_char(Sysdate, 'hh24:mi:ss') );
141: select sum(1) INTO l_row_pushed
142: from opi_ids_push_log
143: where push_flag=1
144: and rownum < 2;
145:
146: BEGIN

Line 158: -- populate opi_ids_push_log.edw_base_uom, edw_conv_rate

154:
155:
156: if (l_row_pushed > 0) THEN
157: -- --------------------------------------------------------
158: -- populate opi_ids_push_log.edw_base_uom, edw_conv_rate
159: -- --------------------------------------------------------
160: FOR l_org_date IN l_org_date_csr LOOP
161:
162:

Line 212: UPDATE opi_ids_push_log

208: -- l_prev_org_id || ' on ' || To_char( l_trx_date, 'dd/mm/yyyy') );
209: END;
210:
211: IF l_org_conv_rate_flag THEN
212: UPDATE opi_ids_push_log
213: SET base_currency_code = l_base_currency_code,
214: edw_conv_rate = l_conv_rate
215: WHERE organization_id = l_org_date.organization_id
216: AND trx_date = l_org_date.trx_date

Line 229: Update opi_ids_push_log

225: -- Get UOMs and Conversion Rates
226: -- ---------------------------------------------------------
227:
228: FOR each_uom_data_record IN get_uom_data_cursor LOOP
229: Update opi_ids_push_log
230: SET
231: EDW_Base_UOM = each_uom_data_record.EDW_Base_UOM,
232: EDW_uom_Conv_Rate = each_uom_data_record.EDW_uom_Conv_Rate
233: where

Line 481: edw_log.put_line(' Calling UPDATE opi_ids_push_log');

477: l_exception_msg,
478: l_from_date,
479: l_to_date);
480:
481: edw_log.put_line(' Calling UPDATE opi_ids_push_log');
482: --dbms_output.put_line('after wrapup ' || to_char(Sysdate, 'hh24:mi:ss'));
483: UPDATE opi_ids_push_log
484: SET push_flag=0,
485: last_update_date=sysdate

Line 483: UPDATE opi_ids_push_log

479: l_to_date);
480:
481: edw_log.put_line(' Calling UPDATE opi_ids_push_log');
482: --dbms_output.put_line('after wrapup ' || to_char(Sysdate, 'hh24:mi:ss'));
483: UPDATE opi_ids_push_log
484: SET push_flag=0,
485: last_update_date=sysdate
486: WHERE push_flag=1
487: AND edw_conv_rate IS NOT NULL;