APPS.OPI_DBI_INV_VALUE_INCR_PKG dependencies on OPI_DBI_INTR_MIP_TMP

Line 139: execute immediate 'truncate table ' || g_opi_schema || '.OPI_DBI_INTR_MIP_TMP';

135: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
136: END IF;
137:
138: l_stmt_num := 10;
139: execute immediate 'truncate table ' || g_opi_schema || '.OPI_DBI_INTR_MIP_TMP';
140:
141: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
142: l_debug_msg := 'OPI_DBI_INTR_MIP_TMP table truncated.';
143: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );

Line 142: l_debug_msg := 'OPI_DBI_INTR_MIP_TMP table truncated.';

138: l_stmt_num := 10;
139: execute immediate 'truncate table ' || g_opi_schema || '.OPI_DBI_INTR_MIP_TMP';
140:
141: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
142: l_debug_msg := 'OPI_DBI_INTR_MIP_TMP table truncated.';
143: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
144: END IF;
145:
146: l_stmt_num := 20;

Line 517: l_debug_msg := 'Insert Data into opi_dbi_intr_mip_tmp ';

513: -- For receipts, the roles of the orgs are reversed.
514:
515: l_stmt_num :=30;
516: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
517: l_debug_msg := 'Insert Data into opi_dbi_intr_mip_tmp ';
518: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
519: END IF;
520:
521: OPI_DBI_INV_VALUE_INIT_PKG.intransit_setup('INCR');

Line 564: -- Index on opi_dbi_intr_mip_tmp Can avoid full table scan

560: --Receipt
561: -- Shipping Conversion Not Required Conversion Not Required
562: -- Receiving Conversion Not Required Conversion Required
563:
564: -- Index on opi_dbi_intr_mip_tmp Can avoid full table scan
565: OPI_DBI_RPT_UTIL_PKG.g_pk_uom_conversion :=1 ;
566: INSERT /*+ append */ INTO OPI_DBI_INTRANSIT_STG(
567: organization_id,
568: inventory_item_id,

Line 625: FROM opi_dbi_intr_mip_tmp mip,

621: SUM (base_transaction_value) value,
622: DECODE (mip.owning_organization_id, msi_fm.organization_id, msi_fm.primary_uom_code
623: ,msi_to.organization_id, msi_to.primary_uom_code) primary_uom_code,
624: TRUNC (mmt1.transaction_date) trx_date
625: FROM opi_dbi_intr_mip_tmp mip,
626: mtl_material_transactions mmt1,
627: (select
628: transaction_id,
629: sum (base_transaction_value) base_transaction_value

Line 804: FROM opi_dbi_intr_mip_tmp mip,

800: ,'D',0,base_transaction_value)) Value,
801: DECODE (mip.owning_organization_id, msi_fm.organization_id, msi_fm.primary_uom_code
802: ,msi_to.organization_id, msi_to.primary_uom_code) primary_uom_code,
803: TRUNC (mmt1.transaction_date) trx_date
804: FROM opi_dbi_intr_mip_tmp mip,
805: mtl_material_transactions mmt1,
806: (SELECT transaction_id,
807: sum(txn_base_value) base_transaction_value
808: ,accounted_flag