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_INV_CCA_PKG dependencies on OPI_DBI_INV_CCA_F

Line 693: -- 'mlog$_opi_dbi_inv_cca_f' );

689: l_stmt_id := 150;
690: -- MV Log on the fact table, because the purge directive on the
691: -- fact table does not work.
692: --EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' ||
693: -- 'mlog$_opi_dbi_inv_cca_f' );
694:
695:
696: l_stmt_id := 160;
697: -- Fact table including the MV log on the table, for efficiency

Line 699: 'opi_dbi_inv_cca_f PURGE MATERIALIZED VIEW LOG');

695:
696: l_stmt_id := 160;
697: -- Fact table including the MV log on the table, for efficiency
698: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' ||
699: 'opi_dbi_inv_cca_f PURGE MATERIALIZED VIEW LOG');
700:
701:
702: -- Not using
703: l_stmt_id := 170;

Line 2082: INSERT /+ append parallel(opi_dbi_inv_cca_f) /

2078:
2079: l_stmt_id := 10;
2080: -- Insert data into the fact table. For explanation of logic,
2081: -- see procedure header.
2082: INSERT /*+ append parallel(opi_dbi_inv_cca_f) */
2083: INTO opi_dbi_inv_cca_f (
2084: organization_id,
2085: inventory_item_id,
2086: cycle_count_header_id,

Line 2083: INTO opi_dbi_inv_cca_f (

2079: l_stmt_id := 10;
2080: -- Insert data into the fact table. For explanation of logic,
2081: -- see procedure header.
2082: INSERT /*+ append parallel(opi_dbi_inv_cca_f) */
2083: INTO opi_dbi_inv_cca_f (
2084: organization_id,
2085: inventory_item_id,
2086: cycle_count_header_id,
2087: abc_class_id,

Line 3843: MERGE INTO opi_dbi_inv_cca_f base