APPS.OPI_DBI_INV_VALUE_INCR_PKG dependencies on OPI_DBI_INTRANSIT_STG

Line 147: execute immediate 'truncate table ' || g_opi_schema || '.OPI_DBI_INTRANSIT_STG';

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;
147: execute immediate 'truncate table ' || g_opi_schema || '.OPI_DBI_INTRANSIT_STG';
148:
149: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
150: l_debug_msg := 'OPI_DBI_INTRANSIT_STG table truncated.';
151: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );

Line 150: l_debug_msg := 'OPI_DBI_INTRANSIT_STG table truncated.';

146: l_stmt_num := 20;
147: execute immediate 'truncate table ' || g_opi_schema || '.OPI_DBI_INTRANSIT_STG';
148:
149: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
150: l_debug_msg := 'OPI_DBI_INTRANSIT_STG table truncated.';
151: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
152: END IF;
153:
154: l_stmt_num := 30;

Line 526: l_debug_msg := 'Inserting data Into opi_dbi_intransit_stg for ODM ';

522: commit;
523:
524: l_stmt_num :=40;
525: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
526: l_debug_msg := 'Inserting data Into opi_dbi_intransit_stg for ODM ';
527: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
528: END IF;
529:
530: -- R12 changes.

Line 566: INSERT /*+ append */ INTO OPI_DBI_INTRANSIT_STG(

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,
569: transaction_date,
570: intransit_qty,

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

707: if OPI_DBI_RPT_UTIL_PKG.g_pk_uom_conversion <>1 then
708: Raise UOM_CONV_ERROR;
709: end if;
710:
711: l_debug_msg := 'Inserted into staging table opi_dbi_intransit_stg - ' || SQL%ROWCOUNT || ' rows. ';
712: OPI_DBI_BOUNDS_PKG.write(g_pkg_name, l_proc_name,l_stmt_num, l_debug_msg);
713:
714: commit;
715: l_stmt_num :=50;

Line 717: l_debug_msg := 'Inserting data Into opi_dbi_intransit_stg for OPM Post R12 ';

713:
714: commit;
715: l_stmt_num :=50;
716: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
717: l_debug_msg := 'Inserting data Into opi_dbi_intransit_stg for OPM Post R12 ';
718: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
719: END IF;
720: OPI_DBI_RPT_UTIL_PKG.g_pk_uom_conversion :=1 ;
721: -- Query to collect POST R12 OPM data

Line 722: INSERT /*+ APPEND */ INTO OPI_DBI_INTRANSIT_STG(

718: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
719: END IF;
720: OPI_DBI_RPT_UTIL_PKG.g_pk_uom_conversion :=1 ;
721: -- Query to collect POST R12 OPM data
722: INSERT /*+ APPEND */ INTO OPI_DBI_INTRANSIT_STG(
723: organization_id,
724: inventory_item_id,
725: transaction_date,
726: intransit_qty,

Line 880: l_debug_msg := 'Inserted into staging table opi_dbi_intransit_stg for OPM Post R12 - ' || SQL%ROWCOUNT || ' rows. ';

876: Raise UOM_CONV_ERROR;
877: end if;
878: commit;
879:
880: l_debug_msg := 'Inserted into staging table opi_dbi_intransit_stg for OPM Post R12 - ' || SQL%ROWCOUNT || ' rows. ';
881: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num,l_debug_msg);
882:
883: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
884: l_debug_msg := 'End of GET_INTRANSIT_ACTIVITY';

Line 1306: from OPI_DBI_INTRANSIT_STG

1302: 0 onhand_value_b_draft,
1303: intransit_value_draft_b intransit_value_b_draft,
1304: 0 wip_value_b_draft,
1305: source
1306: from OPI_DBI_INTRANSIT_STG
1307: UNION ALL
1308: select
1309: organization_id,
1310: NULL,