eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OPI_DBI_JOBS_PKG dependencies on OPI_DBI_JOBS_STG

Line 57: OPI_DBI_JOBS_STG using the fii_currency.get_global_rate_primary

53: The conversion rate work table was truncated during
54: the initialization phase.
55:
56: Get the currency conversion rates based on the data in
57: OPI_DBI_JOBS_STG using the fii_currency.get_global_rate_primary
58: API for the primary global currency and
59: fii_currency.get_global_rate_secondary for the secondary global currency.
60: The primary currency API:
61: 1. finds the conversion rate if one exists.

Line 143: (SELECT /+ parallel (opi_dbi_jobs_stg) /

139: conv.transaction_date) completion_date,
140: conv.f_currency_code func_currency_code
141: FROM opi_dbi_muv_conv_rates conv,
142: mtl_parameters mp,
143: (SELECT /*+ parallel (opi_dbi_jobs_stg) */
144: DISTINCT organization_id,
145: trunc (completion_date) completion_date
146: FROM opi_dbi_jobs_stg) to_conv
147: WHERE nvl (conv.conversion_rate, -999) < 0 -- null is not fine

Line 146: FROM opi_dbi_jobs_stg) to_conv

142: mtl_parameters mp,
143: (SELECT /*+ parallel (opi_dbi_jobs_stg) */
144: DISTINCT organization_id,
145: trunc (completion_date) completion_date
146: FROM opi_dbi_jobs_stg) to_conv
147: WHERE nvl (conv.conversion_rate, -999) < 0 -- null is not fine
148: AND mp.organization_id = to_conv.organization_id
149: AND conv.transaction_date (+) = to_conv.completion_date
150: AND conv.organization_id (+) = to_conv.organization_id

Line 165: (SELECT /+ parallel (opi_dbi_jobs_stg) /

161: conv.transaction_date) completion_date,
162: conv.f_currency_code func_currency_code
163: FROM opi_dbi_muv_conv_rates conv,
164: mtl_parameters mp,
165: (SELECT /*+ parallel (opi_dbi_jobs_stg) */
166: DISTINCT organization_id,
167: trunc (completion_date) completion_date
168: FROM opi_dbi_jobs_stg) to_conv
169: WHERE nvl (conv.sec_conversion_rate, 999) < 0 -- null is fine

Line 168: FROM opi_dbi_jobs_stg) to_conv

164: mtl_parameters mp,
165: (SELECT /*+ parallel (opi_dbi_jobs_stg) */
166: DISTINCT organization_id,
167: trunc (completion_date) completion_date
168: FROM opi_dbi_jobs_stg) to_conv
169: WHERE nvl (conv.sec_conversion_rate, 999) < 0 -- null is fine
170: AND mp.organization_id = to_conv.organization_id
171: AND conv.transaction_date (+) = to_conv.completion_date
172: AND conv.organization_id (+) = to_conv.organization_id)

Line 270: (SELECT /+ parallel (opi_dbi_jobs_stg) /

266: g_program_login_id,
267: g_program_application_id,
268: g_request_id
269: FROM
270: (SELECT /*+ parallel (opi_dbi_jobs_stg) */
271: DISTINCT organization_id, trunc (completion_date) completion_date
272: FROM opi_dbi_jobs_stg) to_conv,
273: (SELECT /*+ leading (hoi) full (hoi) use_hash (gsob)
274: parallel (hoi) parallel (gsob)*/

Line 272: FROM opi_dbi_jobs_stg) to_conv,

268: g_request_id
269: FROM
270: (SELECT /*+ parallel (opi_dbi_jobs_stg) */
271: DISTINCT organization_id, trunc (completion_date) completion_date
272: FROM opi_dbi_jobs_stg) to_conv,
273: (SELECT /*+ leading (hoi) full (hoi) use_hash (gsob)
274: parallel (hoi) parallel (gsob)*/
275: DISTINCT hoi.organization_id, gsob.currency_code
276: FROM hr_organization_information hoi,

Line 428: FROM opi_dbi_jobs_stg fstg,

424: fstg.PROGRAM_ID,
425: fstg.PROGRAM_LOGIN_ID,
426: fstg.PROGRAM_APPLICATION_ID,
427: fstg.REQUEST_ID
428: FROM opi_dbi_jobs_stg fstg,
429: opi_dbi_muv_conv_rates conv
430: WHERE fstg.organization_id = conv.organization_id
431: AND fstg.completion_date = conv.transaction_date;
432:

Line 477: FROM opi_dbi_jobs_stg fstg,

473: fstg.PROGRAM_ID PROGRAM_ID,
474: fstg.PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID,
475: fstg.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID,
476: fstg.REQUEST_ID REQUEST_ID
477: FROM opi_dbi_jobs_stg fstg,
478: opi_dbi_muv_conv_rates conv
479: WHERE fstg.organization_id = conv.organization_id
480: AND fstg.completion_date = conv.transaction_date ) s
481: ON ( f.Organization_id = s.Organization_id

Line 658: '.OPI_DBI_JOBS_STG';

654: --
655: IF fnd_installation.get_app_info('OPI', l_status,
656: l_industry, l_opi_schema) THEN
657: execute immediate 'truncate table ' || l_opi_schema ||
658: '.OPI_DBI_JOBS_STG';
659: --execute immediate 'truncate table ' || l_opi_schema ||
660: -- '.MLOG$_OPI_DBI_JOBS_F';
661: execute immediate 'truncate table ' || l_opi_schema ||
662: '.OPI_DBI_JOBS_F PURGE MATERIALIZED VIEW LOG';

Line 726: INTO opi_dbi_jobs_stg f (

722: /* Insert into Jobs Staging Table */
723:
724: /* OPI Jobs master extraction into Jobs Staging Table */
725: INSERT /*+ APPEND PARALLEL(f) */
726: INTO opi_dbi_jobs_stg f (
727: organization_id,
728: job_id,
729: job_type,
730: status,

Line 894: INSERT /+ APPEND PARALLEL(f) / INTO OPI_DBI_JOBS_STG f

890: -- RAISE_APPLICATION_ERROR(-20000, errbuf);
891: --END IF;
892:
893: /********* OPM Insert *********************************/
894: INSERT /*+ APPEND PARALLEL(f) */ INTO OPI_DBI_JOBS_STG f
895: (
896: organization_id,
897: job_id,
898: job_type,

Line 1120: MERGE INTO OPI_DBI_JOBS_STG f USING

1116:
1117: l_stmt_num := 10;
1118: /* OPI Jobs master extraction into Jobs Staging Table */
1119:
1120: MERGE INTO OPI_DBI_JOBS_STG f USING
1121: (
1122: Select
1123: JOBS.ORGANIZATION_ID,
1124: JOB_ID,

Line 1335: MERGE INTO OPI_DBI_JOBS_STG f USING

1331: CLOSE OPI_DBI_RUN_LOG_CURR_CSR;
1332:
1333: l_stmt_num := 10;
1334:
1335: MERGE INTO OPI_DBI_JOBS_STG f USING
1336: (
1337: select
1338: hdr.organization_id Organization_id,
1339: hdr.batch_id Job_id,

Line 1549: '.OPI_DBI_JOBS_STG';

1545: execute immediate 'truncate table ' || l_opi_schema ||
1546: '.OPI_DBI_MUV_CONV_RATES';
1547:
1548: execute immediate 'truncate table ' || l_opi_schema ||
1549: '.OPI_DBI_JOBS_STG';
1550: END IF;
1551:
1552: l_stmt_num := 40;
1553: GET_OPI_JOBS_INCR_LOAD(errbuf, retcode);