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_VALUE_INIT_PKG dependencies on OPI_DBI_INTR_MIP_TMP

Line 201: -- OPI_DBI_INTR_MIP_TMP

197: -- Note: OPI_DBI_INV_TYPE_CODES is not cleaned anywhere.
198: -- Intransit Tables:
199: -- OPI_DBI_INTR_SUP_TMP
200: -- OPI_DBI_INTR_MMT_TMP
201: -- OPI_DBI_INTR_MIP_TMP
202: -- OPI_DBI_INTRANSIT_STG
203: -- WIP Tables
204: -- OPI_DBI_WIP_STG
205: -- Onhand WIP Tables

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

284: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg);
285: END IF;
286:
287: l_stmt_num := 80;
288: execute immediate 'truncate table ' || g_opi_schema || '.OPI_DBI_INTR_MIP_TMP';
289:
290: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
291: l_debug_msg := 'OPI_DBI_INTR_MIP_TMP table truncated.';
292: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );

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

287: l_stmt_num := 80;
288: execute immediate 'truncate table ' || g_opi_schema || '.OPI_DBI_INTR_MIP_TMP';
289:
290: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
291: l_debug_msg := 'OPI_DBI_INTR_MIP_TMP table truncated.';
292: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
293: END IF;
294:
295: l_stmt_num := 90;

Line 903: --In opi_dbi_intr_mip_tmp , which contains shipping network information for

899:
900: -------------------------------------------------------------------------------
901: --This Procedure will collect data into temp table required for Intransit
902: --Initial Load
903: --In opi_dbi_intr_mip_tmp , which contains shipping network information for
904: --discrete organization till now(Pre R12), shipping network between all
905: --type of organization will be collected along with
906: --process enabled flag info
907: --Data from MMT which has been moved to opi_dbi_intr_mmt_tmp for discrete

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

942: -- For receipts, the roles of the orgs are reversed.
943: IF p_mode = 'INIT' or p_mode = 'INCR' THEN
944: l_stmt_num :=10;
945: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
946: l_debug_msg := 'Insert Data into opi_dbi_intr_mip_tmp ';
947: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
948: END IF;
949:
950: INSERT /*+append parallel(opi_dbi_intr_mip_tmp) */

Line 950: INSERT /+append parallel(opi_dbi_intr_mip_tmp) /

946: l_debug_msg := 'Insert Data into opi_dbi_intr_mip_tmp ';
947: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
948: END IF;
949:
950: INSERT /*+append parallel(opi_dbi_intr_mip_tmp) */
951: INTO opi_dbi_intr_mip_tmp (
952: from_organization_id,
953: to_organization_id,
954: owning_organization_id,

Line 951: INTO opi_dbi_intr_mip_tmp (

947: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
948: END IF;
949:
950: INSERT /*+append parallel(opi_dbi_intr_mip_tmp) */
951: INTO opi_dbi_intr_mip_tmp (
952: from_organization_id,
953: to_organization_id,
954: owning_organization_id,
955: owning_org_process_flag,

Line 989: l_debug_msg := 'Inserted into staging table opi_dbi_intr_mip_tmp - ' || SQL%ROWCOUNT || ' rows. ';

985: WHERE NVL(fob_point,-1) in (1,2)) mip_outer
986: WHERE mip_outer.owning_organization_id =mp.organization_id
987: ;
988:
989: l_debug_msg := 'Inserted into staging table opi_dbi_intr_mip_tmp - ' || SQL%ROWCOUNT || ' rows. ';
990: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num,l_debug_msg);
991:
992: commit;
993: END IF;

Line 1146: -- opi_dbi_intr_mip_tmp,

1142: -------------------------------------------------------------------------------
1143: --In This procedure, Inception Quantities for Intransit Inventory is collected
1144: --In Procedure Intransit setup, data have been collceted into
1145: --following tables
1146: -- opi_dbi_intr_mip_tmp,
1147: -- opi_dbi_intr_mmt_tmp
1148: -- and opi_dbi_intr_sup_tmp,
1149: --which are in sync(approx) with each other.
1150: --We will use these three tables to collect data for inception quantities.

Line 1239: OPI_DBI_INTR_MIP_TMP mip,

1235: 2,mmt1.transfer_cost_group_id,
1236: mmt1.cost_group_id)
1237: ),-1) cost_group_id
1238: FROM OPI_DBI_INTR_MMT_TMP mmt1,
1239: OPI_DBI_INTR_MIP_TMP mip,
1240: MTL_PARAMETERS mp,
1241: MTL_SYSTEM_ITEMS msi_fm,
1242: MTL_SYSTEM_ITEMS msi_to
1243: WHERE mmt1.organization_id = mip.from_organization_id

Line 1531: -- OPI_DBI_INTR_MIP_TMP

1527: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
1528: END IF;
1529:
1530: -- INTRANSIT_SETUP collect data into following temp tables.
1531: -- OPI_DBI_INTR_MIP_TMP
1532: -- OPI_DBI_INTR_SUP_TMP
1533: -- OPI_DBI_INTR_MMT_TMP
1534: Intransit_setup('INIT'); --R12 moved here
1535:

Line 1638: FROM opi_dbi_intr_mip_tmp mip,

1634: DECODE (mip.owning_organization_id, msi_fm.organization_id, msi_fm.primary_uom_code
1635: ,msi_to.organization_id, msi_to.primary_uom_code) primary_uom_code,
1636: TRUNC (mmt1.transaction_date) trx_date,
1637: mip.owning_org_process_flag process_flag -- Bug fix: 5362465
1638: FROM opi_dbi_intr_mip_tmp mip,
1639: opi_dbi_intr_mmt_tmp mmt1,
1640: (select
1641: transaction_id,
1642: sum (base_transaction_value) base_transaction_value

Line 1820: FROM opi_dbi_intr_mip_tmp mip,

1816: DECODE (mip.owning_organization_id, msi_fm.organization_id, msi_fm.primary_uom_code
1817: ,msi_to.organization_id, msi_to.primary_uom_code) primary_uom_code,
1818:
1819: TRUNC (mmt1.transaction_date) trx_date
1820: FROM opi_dbi_intr_mip_tmp mip,
1821: opi_dbi_intr_mmt_tmp mmt1,
1822: (SELECT transaction_id,
1823: sum(txn_base_value) base_transaction_value
1824: ,accounted_flag