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_F

Line 368: INTO opi_dbi_jobs_f f (

364: l_row_count NUMBER;
365: BEGIN
366:
367: INSERT /*+ append parallel(f) */
368: INTO opi_dbi_jobs_f f (
369: organization_id,
370: job_id,
371: job_type,
372: status,

Line 447: MERGE INTO OPI_DBI_JOBS_F f

443: RETURN NUMBER
444: IS
445: l_row_count NUMBER;
446: BEGIN
447: MERGE INTO OPI_DBI_JOBS_F f
448: USING (
449: SELECT
450: fstg.organization_id,
451: fstg.job_id,

Line 646: IF BIS_COLLECTION_UTILITIES.SETUP( 'OPI_DBI_JOBS_F' ) = FALSE THEN

642: l_list(3) := 'BIS_PRIMARY_RATE_TYPE';
643:
644: IF (bis_common_parameters.check_global_parameters(l_list)) THEN
645:
646: IF BIS_COLLECTION_UTILITIES.SETUP( 'OPI_DBI_JOBS_F' ) = FALSE THEN
647: RAISE_APPLICATION_ERROR(-20000, errbuf);
648: END IF;
649:
650: l_stmt_num := 8;

Line 660: -- '.MLOG$_OPI_DBI_JOBS_F';

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';
663: execute immediate 'truncate table ' || l_opi_schema ||
664: '.OPI_DBI_MUV_CONV_RATES';

Line 662: '.OPI_DBI_JOBS_F PURGE MATERIALIZED VIEW LOG';

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';
663: execute immediate 'truncate table ' || l_opi_schema ||
664: '.OPI_DBI_MUV_CONV_RATES';
665: END IF;
666:

Line 1231: ((NOT EXISTS (SELECT 'X' FROM OPI_DBI_JOBS_F WHERE JOB_ID = JOBS.JOB_ID AND JOB_TYPE = JOBS.JOB_TYPE)

1227: MSI.ORGANIZATION_ID = JOBS.ORGANIZATION_ID AND
1228: itemcost.cost_type_id in (1,2,5,6) and
1229: itemcost.organization_id = jobs.organization_id and
1230: itemcost.inventory_item_id = jobs.Assembly_Item_id and
1231: ((NOT EXISTS (SELECT 'X' FROM OPI_DBI_JOBS_F WHERE JOB_ID = JOBS.JOB_ID AND JOB_TYPE = JOBS.JOB_TYPE)
1232: AND JOBS.JOB_STATUS_CODE IN (1,2,3,4,5,6,7,12,14,15)
1233: ) -- New jobs in any of the 3 statuses considered: Closed, Complete - No Charges, Cancelled
1234: OR (EXISTS (SELECT 'X' FROM OPI_DBI_JOBS_F WHERE JOB_ID = JOBS.JOB_ID AND JOB_TYPE = JOBS.JOB_TYPE) AND JOBS.LAST_UPDATE_DATE > g_last_collection_date) ) -- Jobs in Jobs Master that have been updated
1235: ) s

Line 1234: OR (EXISTS (SELECT 'X' FROM OPI_DBI_JOBS_F WHERE JOB_ID = JOBS.JOB_ID AND JOB_TYPE = JOBS.JOB_TYPE) AND JOBS.LAST_UPDATE_DATE > g_last_collection_date) ) -- Jobs in Jobs Master that have been updated

1230: itemcost.inventory_item_id = jobs.Assembly_Item_id and
1231: ((NOT EXISTS (SELECT 'X' FROM OPI_DBI_JOBS_F WHERE JOB_ID = JOBS.JOB_ID AND JOB_TYPE = JOBS.JOB_TYPE)
1232: AND JOBS.JOB_STATUS_CODE IN (1,2,3,4,5,6,7,12,14,15)
1233: ) -- New jobs in any of the 3 statuses considered: Closed, Complete - No Charges, Cancelled
1234: OR (EXISTS (SELECT 'X' FROM OPI_DBI_JOBS_F WHERE JOB_ID = JOBS.JOB_ID AND JOB_TYPE = JOBS.JOB_TYPE) AND JOBS.LAST_UPDATE_DATE > g_last_collection_date) ) -- Jobs in Jobs Master that have been updated
1235: ) s
1236: ON (f.Organization_id = s.Organization_id
1237: and f.Job_id = s.Job_id
1238: and f.Job_Type = s.Job_Type

Line 1381: ( (NOT EXISTS (SELECT 'X' FROM OPI_DBI_JOBS_F WHERE JOB_ID = hdr.batch_ID AND JOB_TYPE = 4)

1377: where hdr.batch_id = dtl.batch_id
1378: and dtl.line_type in (1,2) /* coproducts and by-products*/
1379: and nvl(ACTUAL_START_DATE, g_global_start_date) >= g_global_start_date
1380: and
1381: ( (NOT EXISTS (SELECT 'X' FROM OPI_DBI_JOBS_F WHERE JOB_ID = hdr.batch_ID AND JOB_TYPE = 4)
1382: and hdr.batch_status in (2,3,4,-1) /* wip, completed, closed, cancelled */
1383: )
1384: OR (EXISTS (SELECT 'X' FROM OPI_DBI_JOBS_F WHERE JOB_ID = hdr.batch_ID AND JOB_TYPE = 4)
1385: AND hdr.LAST_UPDATE_DATE > g_opm_last_collection_date) ) -- Jobs in Jobs Master that have been updated

Line 1384: OR (EXISTS (SELECT 'X' FROM OPI_DBI_JOBS_F WHERE JOB_ID = hdr.batch_ID AND JOB_TYPE = 4)

1380: and
1381: ( (NOT EXISTS (SELECT 'X' FROM OPI_DBI_JOBS_F WHERE JOB_ID = hdr.batch_ID AND JOB_TYPE = 4)
1382: and hdr.batch_status in (2,3,4,-1) /* wip, completed, closed, cancelled */
1383: )
1384: OR (EXISTS (SELECT 'X' FROM OPI_DBI_JOBS_F WHERE JOB_ID = hdr.batch_ID AND JOB_TYPE = 4)
1385: AND hdr.LAST_UPDATE_DATE > g_opm_last_collection_date) ) -- Jobs in Jobs Master that have been updated
1386: group by
1387: hdr.organization_id,
1388: hdr.batch_id,

Line 1491: IF BIS_COLLECTION_UTILITIES.SETUP( 'OPI_DBI_JOBS_F' ) = false then

1487: l_list(3) := 'BIS_PRIMARY_RATE_TYPE';
1488:
1489: IF (bis_common_parameters.check_global_parameters(l_list)) THEN
1490:
1491: IF BIS_COLLECTION_UTILITIES.SETUP( 'OPI_DBI_JOBS_F' ) = false then
1492: RAISE_APPLICATION_ERROR(-20000, errbuf);
1493: END IF;
1494:
1495: l_stmt_num := 10;