APPS.OPI_DBI_JOB_TXN_STG_PKG dependencies on OPI_DBI_MUV_CONV_RATES

Line 56: FROM opi_dbi_muv_conv_rates

52: IS
53:
54: CURSOR invalid_rates_exist_csr IS
55: SELECT 1
56: FROM opi_dbi_muv_conv_rates
57: WHERE (nvl (conversion_rate, -999) < 0
58: OR nvl (sec_conversion_rate, 999) < 0)
59: AND rownum < 2;
60:

Line 80: FROM opi_dbi_muv_conv_rates conv,

76: decode (conv.conversion_rate,
77: C_EURO_MISSING_AT_START, g_euro_start_date,
78: conv.transaction_date) transaction_date,
79: conv.f_currency_code func_currency_code
80: FROM opi_dbi_muv_conv_rates conv,
81: mtl_parameters mp,
82: (SELECT
83: DISTINCT organization_id,
84: trunc (transaction_date) transaction_date

Line 102: FROM opi_dbi_muv_conv_rates conv,

98: decode (conv.sec_conversion_rate,
99: C_EURO_MISSING_AT_START, g_euro_start_date,
100: conv.transaction_date) transaction_date,
101: conv.f_currency_code func_currency_code
102: FROM opi_dbi_muv_conv_rates conv,
103: mtl_parameters mp,
104: (SELECT
105: DISTINCT organization_id,
106: trunc (transaction_date) transaction_date

Line 170: INTO opi_dbi_muv_conv_rates rates (

166:
167: -- By selecting distinct org and currency code from the gl_set_of_books
168: -- and hr_organization_information, take care of duplicate codes.
169: INSERT /*+ append parallel(rates) */
170: INTO opi_dbi_muv_conv_rates rates (
171: organization_id,
172: f_currency_code,
173: transaction_date,
174: conversion_rate,

Line 237: UPDATE /*+ parallel (opi_dbi_muv_conv_rates) */

233: -- update the secondary with the primary
234: IF (l_pri_sec_curr_same = 1) THEN
235: --{
236:
237: UPDATE /*+ parallel (opi_dbi_muv_conv_rates) */
238: opi_dbi_muv_conv_rates
239: SET sec_conversion_rate = conversion_rate;
240:
241: -- safe to commit, as before

Line 238: opi_dbi_muv_conv_rates

234: IF (l_pri_sec_curr_same = 1) THEN
235: --{
236:
237: UPDATE /*+ parallel (opi_dbi_muv_conv_rates) */
238: opi_dbi_muv_conv_rates
239: SET sec_conversion_rate = conversion_rate;
240:
241: -- safe to commit, as before
242: commit;

Line 1840: opi_dbi_muv_conv_rates crates

1836: s_program_application_id,
1837: s_request_id
1838: from
1839: OPI_DBI_JOBS_TXN_STG jobs_txn,
1840: opi_dbi_muv_conv_rates crates
1841: where
1842: etl_type_id = 1 and
1843: crates.organization_id = jobs_txn.organization_id and
1844: trunc(jobs_txn.transaction_date) = crates.transaction_date

Line 1936: opi_dbi_muv_conv_rates crates

1932: s_program_application_id PROGRAM_APPLICATION_ID,
1933: s_request_id REQUEST_ID
1934: from
1935: OPI_DBI_JOBS_TXN_STG jobs_txn,
1936: opi_dbi_muv_conv_rates crates
1937: where
1938: etl_type_id = 1 and
1939: crates.organization_id = jobs_txn.organization_id and
1940: trunc(jobs_txn.transaction_date) = crates.transaction_date

Line 3474: opi_dbi_muv_conv_rates crates

3470: s_program_application_id,
3471: s_request_id
3472: from
3473: OPI_DBI_JOBS_TXN_STG jobs_txn,
3474: opi_dbi_muv_conv_rates crates
3475: where
3476: jobs_txn.etl_type_id = 2 and
3477: jobs_txn.organization_id = crates.organization_id and
3478: trunc(jobs_txn.transaction_date) = crates.transaction_date

Line 3573: opi_dbi_muv_conv_rates crates

3569: s_program_application_id PROGRAM_APPLICATION_ID,
3570: s_request_id REQUEST_ID
3571: from
3572: OPI_DBI_JOBS_TXN_STG jobs_txn,
3573: opi_dbi_muv_conv_rates crates
3574: where
3575: jobs_txn.etl_type_id = 2 and
3576: jobs_txn.organization_id = crates.organization_id and
3577: trunc(jobs_txn.transaction_date) = crates.transaction_date

Line 3780: opi_dbi_muv_conv_rates crates

3776: s_program_application_id PROGRAM_APPLICATION_ID,
3777: s_request_id REQUEST_ID
3778: FROM
3779: OPI_DBI_JOBS_TXN_STG jobs_txn,
3780: opi_dbi_muv_conv_rates crates
3781: WHERE
3782: etl_type_id = 3 and
3783: jobs_txn.organization_id = crates.organization_id and
3784: trunc(jobs_txn.transaction_date) = crates.transaction_date

Line 3872: opi_dbi_muv_conv_rates crates

3868: s_program_application_id PROGRAM_APPLICATION_ID,
3869: s_request_id REQUEST_ID
3870: FROM
3871: OPI_DBI_JOBS_TXN_STG jobs_txn,
3872: opi_dbi_muv_conv_rates crates
3873: WHERE
3874: etl_type_id = 3 and
3875: jobs_txn.organization_id = crates.organization_id and
3876: trunc(jobs_txn.transaction_date) = crates.transaction_date

Line 4013: execute immediate 'truncate table ' || l_opi_schema || '.opi_dbi_muv_conv_rates';

4009: --execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_OPM_SCALED_MTL';
4010: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_JOB_MTL_STD_QTY_TMP';
4011: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_JOBS_TXN_STG';
4012: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_JOBS_TXN_MMT_STG';
4013: execute immediate 'truncate table ' || l_opi_schema || '.opi_dbi_muv_conv_rates';
4014: --}
4015: END IF;
4016:
4017: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);