APPS.OPI_DBI_INV_VALUE_OPM_INIT_PKG dependencies on OPI_DBI_OPM_INCEPTION_QTY

Line 55: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_OPM_INCEPTION_QTY ';

51: bis_collection_utilities.put_line('... OPI_DBI_OPM_CONVERSION_RATES');
52:
53: l_stmt_num := 50;
54: /* Truncating OPM Inception Qtys */
55: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_OPM_INCEPTION_QTY ';
56: bis_collection_utilities.put_line('... OPI_DBI_OPM_INCEPTION_QTY');
57:
58: l_stmt_num := 60;
59: /* Truncating OPM Current Permanent Subledger Rows */

Line 56: bis_collection_utilities.put_line('... OPI_DBI_OPM_INCEPTION_QTY');

52:
53: l_stmt_num := 50;
54: /* Truncating OPM Inception Qtys */
55: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_OPM_INCEPTION_QTY ';
56: bis_collection_utilities.put_line('... OPI_DBI_OPM_INCEPTION_QTY');
57:
58: l_stmt_num := 60;
59: /* Truncating OPM Current Permanent Subledger Rows */
60: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_OPM_INV_LED_CURRENT ';

Line 216: INSERT INTO opi_dbi_opm_inception_qty

212:
213: /* Insert Inception Balances Into its Staging table */
214: l_stmt_num := 10;
215:
216: INSERT INTO opi_dbi_opm_inception_qty
217: (item_id, whse_code, type, quantity)
218: SELECT
219: item_id, whse_code, 1, SUM(onhand_qty) onhand_qty
220: FROM

Line 281: opi_dbi_opm_inception_qty q,

277: (whse_code, orgn_code, item_id, trans_date)
278: SELECT
279: DISTINCT q.whse_code, w.orgn_code, q.item_id, id.transaction_date
280: FROM
281: opi_dbi_opm_inception_qty q,
282: opi_dbi_inv_value_log id,
283: ic_whse_mst w,
284: sy_orgn_mst o,
285: sy_orgn_mst c

Line 337: opi_dbi_opm_inception_qty q,

333: msi.primary_uom_code,
334: SUM(DECODE(q.type, 1, q.quantity * c.total_cost, 0)) onhand_value_b,
335: SUM(DECODE(q.type, 2, q.quantity * c.total_cost, 0)) intransit_value_b
336: FROM
337: opi_dbi_opm_inception_qty q,
338: opi_pmi_cost_result_gtmp c,
339: ic_item_mst_b iim,
340: ic_whse_mst w,
341: mtl_system_items_b msi

Line 431: INSERT INTO opi_dbi_opm_inception_qty

427:
428: BEGIN
429: proc_name := 'Get_OPM_Intransit_Balance ' ;
430:
431: INSERT INTO opi_dbi_opm_inception_qty
432: (whse_code, item_id, type, quantity)
433: SELECT whse, item, 2, sum (qty) qty
434: FROM ( /* inception = current - total */
435: SELECT whse, item, qty

Line 868: tabname => 'OPI_DBI_OPM_INCEPTION_QTY',

864: Get_OPM_Intransit_Balance(errbuf, retcode);
865:
866: fnd_stats.gather_table_stats(
867: ownname => g_opi_schema,
868: tabname => 'OPI_DBI_OPM_INCEPTION_QTY',
869: percent => 10);
870:
871: Cost_Inception_Quantities;
872: