APPS.OPI_DBI_INV_VALUE_OPM_INIT_PKG dependencies on OPI_DBI_OPM_INV_STG

Line 34: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_OPM_INV_STG ';

30: bis_collection_utilities.put_line('Initializing Tables:');
31:
32: l_stmt_num := 10;
33: /* Truncating Staging Tables */
34: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_OPM_INV_STG ';
35: bis_collection_utilities.put_line('... OPI_DBI_OPM_INV_STG');
36:
37: l_stmt_num := 20;
38: /* Truncating Base Table */

Line 35: bis_collection_utilities.put_line('... OPI_DBI_OPM_INV_STG');

31:
32: l_stmt_num := 10;
33: /* Truncating Staging Tables */
34: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_OPM_INV_STG ';
35: bis_collection_utilities.put_line('... OPI_DBI_OPM_INV_STG');
36:
37: l_stmt_num := 20;
38: /* Truncating Base Table */
39: DELETE FROM OPI_DBI_INV_VALUE_F WHERE source = 2;

Line 310: INSERT INTO opi_dbi_opm_inv_stg

306: PROCEDURE Create_Inception_Balances
307: IS
308: l_row_count NUMBER;
309: BEGIN
310: INSERT INTO opi_dbi_opm_inv_stg
311: (
312: ORGANIZATION_ID,
313: INVENTORY_ITEM_ID,
314: /* csheu added the following line */

Line 713: INSERT INTO opi_dbi_opm_inv_stg

709: PROCEDURE Get_OPM_WIP_Balance(errbuf in out NOCOPY varchar2, retcode in out NOCOPY varchar2)
710: IS
711: BEGIN
712:
713: INSERT INTO opi_dbi_opm_inv_stg
714: (
715: ORGANIZATION_ID,
716: INVENTORY_ITEM_ID,
717: TRANSACTION_DATE,

Line 877: tabname => 'OPI_DBI_OPM_INV_STG',

873: Create_Inception_Balances;
874:
875: fnd_stats.gather_table_stats(
876: ownname => g_opi_schema,
877: tabname => 'OPI_DBI_OPM_INV_STG',
878: percent => 10);
879:
880: Get_OPM_WIP_Balance(errbuf, retcode);
881: