[Home] [Help]
195: -- OPI_PMI_COST_PARAM_GTMP
196: -- OPI_DBI_INV_VALUE_LOG -- added as part of CPCS Change.
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
268: -- not required to be truncated. used only in old code
269: -- execute immediate 'truncate table ' || g_opi_schema || '.OPI_PMI_COST_PARAM_GTMP';
270:
271: l_stmt_num := 60;
272: execute immediate 'truncate table ' || g_opi_schema || '.OPI_DBI_INTR_SUP_TMP';
273:
274: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
275: l_debug_msg := 'OPI_DBI_INTR_SUP_TMP table truncated.';
276: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
271: l_stmt_num := 60;
272: execute immediate 'truncate table ' || g_opi_schema || '.OPI_DBI_INTR_SUP_TMP';
273:
274: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
275: l_debug_msg := 'OPI_DBI_INTR_SUP_TMP table truncated.';
276: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
277: END IF;
278:
279: l_stmt_num := 70;
1056: commit;
1057:
1058: l_stmt_num :=30;
1059: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
1060: l_debug_msg := 'Insert into opi_dbi_intr_sup_tmp. ';
1061: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
1062: END IF;
1063: -- Extract all data from mtl_supply into a temp table.
1064: -- Make sure that the primary quantity used is that
1067: -- Bug 4760492
1068: -- MTL supply contains Transaction qty for from/shipping organization.
1069: -- It might not be same as primary quantity.
1070: -- code has been changed for this
1071: INSERT /*append parallel(opi_dbi_intr_sup_tmp) */
1072: INTO OPI_DBI_INTR_SUP_TMP (
1073: intransit_owning_org_id,
1074: from_organization_id,
1075: to_organization_id,
1068: -- MTL supply contains Transaction qty for from/shipping organization.
1069: -- It might not be same as primary quantity.
1070: -- code has been changed for this
1071: INSERT /*append parallel(opi_dbi_intr_sup_tmp) */
1072: INTO OPI_DBI_INTR_SUP_TMP (
1073: intransit_owning_org_id,
1074: from_organization_id,
1075: to_organization_id,
1076: qty,
1120: to_organization_id,
1121: item_id,
1122: cost_group_id;
1123: */
1124: l_debug_msg :='Inserted into staging table opi_dbi_intr_sup_tmp - ' || SQL%ROWCOUNT || ' rows. ';
1125: opi_dbi_bounds_pkg.write(g_pkg_name, l_proc_name,l_stmt_num,l_debug_msg);
1126:
1127: commit;
1128: END IF;
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.
1151: --For Pre R12 OPM data , we will use opi_dbi_intr_sup_tmp table
1152: --Data collection is similar to initial Load; here only quantities are
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.
1151: --For Pre R12 OPM data , we will use opi_dbi_intr_sup_tmp table
1152: --Data collection is similar to initial Load; here only quantities are
1153: --collected on inception date.
1154: --No bound are used for inception load. Also all uncosted transaction are
1155: --considered.
1280: sup.item_id inventory_item_id,
1281: sum(sup.qty) tot_prim_qty,
1282: nvl (sup.cost_group_id, p.default_cost_group_id)
1283: cost_group_id
1284: FROM OPI_DBI_INTR_SUP_TMP sup,
1285: MTL_SYSTEM_ITEMS msi,
1286: MTL_PARAMETERS p
1287: WHERE sup.intransit_owning_org_id = msi.organization_id
1288: AND p.organization_id = msi.organization_id
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:
1536: l_stmt_num :=20;