31: secondary_rate)
32: SELECT currency_code,
33: effective_date,
34: decode(l_prim_currency_code, NULL, TO_NUMBER(NULL),
35: fii_currency.get_rate(currency_code, l_prim_currency_code,
36: effective_date, l_prim_rate_type)) primary_rate,
37: decode(l_sec_currency_code, NULL, TO_NUMBER(NULL),
38: fii_currency.get_rate(currency_code, l_sec_currency_code,
39: effective_date, l_sec_rate_type)) secondary_rate
34: decode(l_prim_currency_code, NULL, TO_NUMBER(NULL),
35: fii_currency.get_rate(currency_code, l_prim_currency_code,
36: effective_date, l_prim_rate_type)) primary_rate,
37: decode(l_sec_currency_code, NULL, TO_NUMBER(NULL),
38: fii_currency.get_rate(currency_code, l_sec_currency_code,
39: effective_date, l_sec_rate_type)) secondary_rate
40: FROM (SELECT /*+ PARALLEL(tmp) */ DISTINCT currency_code ,
41: effective_date FROM eni_dbi_item_cost_stg tmp);
42:
49: secondary_rate)
50: SELECT currency_code,
51: effective_date,
52: decode(l_prim_currency_code, NULL, TO_NUMBER(NULL),
53: fii_currency.get_rate(currency_code, l_prim_currency_code,
54: effective_date, l_prim_rate_type)) primary_rate,
55: decode(l_sec_currency_code, NULL, TO_NUMBER(NULL),
56: fii_currency.get_rate(currency_code, l_sec_currency_code,
57: effective_date, l_sec_rate_type)) secondary_rate
52: decode(l_prim_currency_code, NULL, TO_NUMBER(NULL),
53: fii_currency.get_rate(currency_code, l_prim_currency_code,
54: effective_date, l_prim_rate_type)) primary_rate,
55: decode(l_sec_currency_code, NULL, TO_NUMBER(NULL),
56: fii_currency.get_rate(currency_code, l_sec_currency_code,
57: effective_date, l_sec_rate_type)) secondary_rate
58: FROM (SELECT DISTINCT currency_code ,
59: effective_date FROM eni_dbi_item_cost_stg);
60: END IF;
180: sysdate creation_date,
181: l_application_user_id created_by,
182: l_application_user_id last_update_login,
183: currency_code,
184: null --fii_currency.get_global_rate_primary(currency_code, effective_date) conversion_rate
185: from (
186: select /*+ parallel(cec) parallel(hoi) */
187: cec.inventory_item_id,
188: cec.organization_id,
239: sysdate,
240: 1,
241: 1,
242: gsob.currency_code,
243: null --fii_currency.get_global_rate_primary (gsob.currency_code,trunc(x.asofdate))
244: from (
245: select /*+ no_merge parallel(mmt) parallel(cql) parallel(mp) full(mmt)
246: swap_join_inputs(cql) */ mmt.inventory_item_id,
247: mmt.organization_id,
755: sysdate creation_date,
756: l_application_user_id created_by,
757: l_application_user_id last_update_login,
758: currency_code,
759: null --fii_currency.get_global_rate_primary(currency_code, effective_date) conversion_rate
760: from (
761: select
762: cec.inventory_item_id,
763: cec.organization_id,
830: sysdate,
831: 1,
832: 1,
833: gsob.currency_code,
834: null --fii_currency.get_global_rate_primary (gsob.currency_code,trunc(x.asofdate))
835: from (
836: select /*+ no_merge parallel(mmt) parallel(cql) parallel(mp)
837: swap_join_inputs(cql) */ mmt.inventory_item_id,
838: mmt.organization_id,