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.ISC_FS_INV_USG_ETL_PKG dependencies on OPI_DBI_CONC_PROG_RUN_LOG

Line 429: be extracted. We will access OPI_DBI_CONC_PROG_RUN_LOG to obtain these upper boundaries. The

425:
426: BIS_COLLECTION_UTILITIES.LOG( 'Log table truncated', 1 );
427:
428: /* Insert into our log table the upper transaction boundaries for every organization to
429: be extracted. We will access OPI_DBI_CONC_PROG_RUN_LOG to obtain these upper boundaries. The
430: incremental load will use these boundaries as starting points. */
431:
432: l_stmt_num := 20;
433: INSERT INTO ISC_FS_INV_USG_LOG

Line 466: OPI_DBI_CONC_PROG_RUN_LOG from_to_txn

462: ,g_program_login_id
463: ,g_program_application_id
464: ,g_request_id
465: FROM
466: OPI_DBI_CONC_PROG_RUN_LOG from_to_txn
467: ,OPI_DBI_CONC_PROG_RUN_LOG from_to_txn_incr
468: /* Change in Boundaries Log table in OPI caused a change in how our code handles MMT boundaries */
469: WHERE
470: from_to_txn.etl_type = 'INVENTORY'

Line 467: ,OPI_DBI_CONC_PROG_RUN_LOG from_to_txn_incr

463: ,g_program_application_id
464: ,g_request_id
465: FROM
466: OPI_DBI_CONC_PROG_RUN_LOG from_to_txn
467: ,OPI_DBI_CONC_PROG_RUN_LOG from_to_txn_incr
468: /* Change in Boundaries Log table in OPI caused a change in how our code handles MMT boundaries */
469: WHERE
470: from_to_txn.etl_type = 'INVENTORY'
471: AND from_to_txn.BOUND_TYPE = 'ID'

Line 500: OPI_DBI_CONC_PROG_RUN_LOG from_to_txn

496: ,g_program_login_id
497: ,g_program_application_id
498: ,g_request_id
499: FROM
500: OPI_DBI_CONC_PROG_RUN_LOG from_to_txn
501: /* Change in Boundaries Log table in OPI caused a change in how our code handles MMT boundaries */
502: WHERE
503: from_to_txn.etl_type = 'INVENTORY'
504: AND from_to_txn.BOUND_TYPE = 'ID'

Line 508: AND not exists (SELECT 'X' FROM OPI_DBI_CONC_PROG_RUN_LOG olog

504: AND from_to_txn.BOUND_TYPE = 'ID'
505: AND from_to_txn.DRIVING_TABLE_CODE = 'MMT'
506: AND from_to_txn.LOAD_TYPE = 'INCR'
507: AND from_to_txn.BOUND_LEVEL_ENTITY_CODE = 'ORGANIZATION'
508: AND not exists (SELECT 'X' FROM OPI_DBI_CONC_PROG_RUN_LOG olog
509: WHERE
510: olog.etl_type = 'INVENTORY'
511: AND olog.BOUND_TYPE = 'ID'
512: AND olog.DRIVING_TABLE_CODE = 'MMT'

Line 819: OPI_DBI_CONC_PROG_RUN_LOG from_to_txn

815: ,from_to_txn.TO_BOUND_ID FROM_TRANSACTION_ID
816: /* This will become the To transaction at the end of the collection. We are temporarily storing the To boundary
817: in the from transaction column */
818: FROM
819: OPI_DBI_CONC_PROG_RUN_LOG from_to_txn
820: WHERE
821: from_to_txn.etl_type = 'INVENTORY'
822: AND from_to_txn.BOUND_TYPE = 'ID'
823: AND from_to_txn.DRIVING_TABLE_CODE = 'MMT'