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_ONH_QTY_STG

Line 206: -- OPI_DBI_ONH_QTY_STG

202: -- OPI_DBI_INTRANSIT_STG
203: -- WIP Tables
204: -- OPI_DBI_WIP_STG
205: -- Onhand WIP Tables
206: -- OPI_DBI_ONH_QTY_STG
207: -- OPI_DBI_INV_BEG_STG
208: -- OPI_DBI_ONHAND_STG
209: -- IF p_stage = 'PRE_INIT' THEN
210: -- Cleanup the OPI_DBI_INV_VALUE_F

Line 312: execute immediate 'truncate table ' || g_opi_schema || '.OPI_DBI_ONH_QTY_STG';

308: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
309: END IF;
310:
311: l_stmt_num := 110;
312: execute immediate 'truncate table ' || g_opi_schema || '.OPI_DBI_ONH_QTY_STG';
313:
314: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
315: l_debug_msg := 'OPI_DBI_ONH_QTY_STG table truncated.';
316: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );

Line 315: l_debug_msg := 'OPI_DBI_ONH_QTY_STG table truncated.';

311: l_stmt_num := 110;
312: execute immediate 'truncate table ' || g_opi_schema || '.OPI_DBI_ONH_QTY_STG';
313:
314: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
315: l_debug_msg := 'OPI_DBI_ONH_QTY_STG table truncated.';
316: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
317: END IF;
318:
319: l_stmt_num := 120;

Line 867: FROM opi_dbi_onh_qty_stg stg1

863: -- it is assumed that there are no draft quantities as of GSD
864: ,decode(stg1.transaction_source,'MOQ',stg1.onhand_qty
865: ,'MMT',-1*(stg1.onhand_qty+stg1.onhand_qty_draft)
866: ,0) onhand_qty
867: FROM opi_dbi_onh_qty_stg stg1
868: WHERE transaction_source IN ('MMT','MOQ')
869: UNION ALL
870: SELECT stg2.organization_id
871: ,stg2.subinventory_code

Line 1947: l_debug_msg := 'Inserting data into OPI_DBI_ONH_QTY_STG ';

1943: */
1944:
1945: l_stmt_num :=10;
1946: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
1947: l_debug_msg := 'Inserting data into OPI_DBI_ONH_QTY_STG ';
1948: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
1949: END IF;
1950: --execute immediate 'alter session force parallel query parallel ' || g_degree;
1951:

Line 1952: INSERT /+ append parallel(OPI_DBI_ONH_QTY_STG) /

1948: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
1949: END IF;
1950: --execute immediate 'alter session force parallel query parallel ' || g_degree;
1951:
1952: INSERT /*+ append parallel(OPI_DBI_ONH_QTY_STG) */
1953: INTO OPI_DBI_ONH_QTY_STG
1954: (organization_id,
1955: subinventory_code,
1956: cost_group_id,

Line 1953: INTO OPI_DBI_ONH_QTY_STG

1949: END IF;
1950: --execute immediate 'alter session force parallel query parallel ' || g_degree;
1951:
1952: INSERT /*+ append parallel(OPI_DBI_ONH_QTY_STG) */
1953: INTO OPI_DBI_ONH_QTY_STG
1954: (organization_id,
1955: subinventory_code,
1956: cost_group_id,
1957: inventory_item_id,

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

2041: NVL(moq.subinventory_code,-1),
2042: NVL(moq.cost_group_id, mp.default_cost_group_id),
2043: moq.inventory_item_id);
2044:
2045: l_debug_msg := 'Inserted into staging table OPI_DBI_ONH_QTY_STG - ' || SQL%ROWCOUNT || ' rows. ';
2046: OPI_DBI_BOUNDS_PKG.write(g_pkg_name, l_proc_name,l_stmt_num, l_debug_msg);
2047:
2048: commit;
2049:

Line 2110: INSERT /+ append parallel(OPI_DBI_ONH_QTY_STG) /

2106: l_debug_msg := 'Inserting data into OPI_DBI_ONHAND_STG ';
2107: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
2108: END IF;
2109:
2110: INSERT /*+ append parallel(OPI_DBI_ONH_QTY_STG) */
2111: INTO OPI_DBI_ONHAND_STG
2112: (organization_id,
2113: subinventory_code,
2114: inventory_item_id,

Line 2429: -- 1. OPI_DBI_ONH_QTY_STG - onhand quantity

2425:
2426: -------------------------------------------------------------------------------
2427: -- This procedure merges data from various staging tables populated in
2428: -- initial load.
2429: -- 1. OPI_DBI_ONH_QTY_STG - onhand quantity
2430: -- 2. provide each table and what all it contains
2431: -- 3. provide conversion rate and costing info as well for inception to balance.
2432:
2433: --In this procedure all all data from staging table is merged

Line 2550: select /+ parallel(OPI_DBI_ONH_QTY_STG) /

2546: source
2547: FROM OPI_DBI_ONHAND_STG
2548: where push_to_fact_flag = 'Y'
2549: UNION ALL
2550: select /*+ parallel(OPI_DBI_ONH_QTY_STG) */
2551: fact.organization_id,
2552: fact.subinventory_code,
2553: fact.inventory_item_id,
2554: fact.transaction_date,

Line 2567: FROM OPI_DBI_ONH_QTY_STG fact

2563: 0 onhand_value_b_draft,
2564: 0 intransit_value_b_draft,
2565: 0 wip_value_b_draft,
2566: source
2567: FROM OPI_DBI_ONH_QTY_STG fact
2568: WHERE push_to_fact_flag = 'Y'
2569: UNION All
2570: select /*+ parallel(opi_dbi_intransit_stg) */
2571: organization_id,

Line 2971: -- 1. OPI_DBI_ONH_QTY_STG -- onhand quantity

2967: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
2968: END IF;
2969: -- This procedure merges data from various
2970: -- staging tables populated in initial load.
2971: -- 1. OPI_DBI_ONH_QTY_STG -- onhand quantity
2972: -- 2. opi_dbi_opm_inv_stg -- Pre r12 OPM DATA
2973: -- 3. OPI_DBI_INTRANSIT_STG -- Intransit Qty and Value
2974: -- 4. OPI_DBI_INV_BEG_STG -- Inception qty and value
2975: -- 5. OPI_DBI_ONHAND_STG -- On hand value