APPS.OPI_DBI_RPT_UTIL_PKG dependencies on IC_LOCT_INV

Line 3688: viz. IC_LOCT_INV.

3684: which was inserted by the 'set'procedure into one of DBI
3685: log table viz. OPI_DBI_CONC_PROG_RUN_LOG.
3686: If such date is not found in the log table, we look at
3687: the max of the last update in the Inventory Balances Table
3688: viz. IC_LOCT_INV.
3689: For a new customer directly going into R12, the above 2
3690: would not give any date, so in that case we simply use the
3691: sysdate for the purpose.
3692: The procedure insert_inv_convergence_date is used to insert

Line 3702: l_inv_migration_date ic_loct_inv.last_update_date%type;

3698: PROCEDURE get_inv_convergence_date (p_inv_migration_date OUT NOCOPY DATE)
3699: IS
3700:
3701: l_stmt_id NUMBER;
3702: l_inv_migration_date ic_loct_inv.last_update_date%type;
3703: l_rowcount NUMBER;
3704: l_proc_name CONSTANT VARCHAR2 (60):= 'get_inv_convergence_date';
3705:
3706: BEGIN

Line 3741: ic_loct_inv

3737: MAX(last_update_date)
3738: INTO
3739: l_inv_migration_date
3740: FROM
3741: ic_loct_inv
3742: WHERE
3743: migrated_ind = 1;
3744: l_stmt_id :=40;
3745: IF l_inv_migration_date IS NOT NULL THEN