APPS.OPI_DBI_INV_VALUE_INIT_PKG dependencies on CST_ITEM_COSTS

Line 533: l_debug_msg := 'form cst_item_costs for which cost is not found till now';

529: l_stmt_num := 30;
530: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
531: l_debug_msg := 'updated data into OPI_DBI_INV_BEG_STG for standard costing organization';
532: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
533: l_debug_msg := 'form cst_item_costs for which cost is not found till now';
534: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
535: END IF;
536:
537:

Line 548: FROM cst_item_costs csc

544: SET (onhand_value_b ,intransit_value_b) =
545: (SELECT /*+ ordered use_hash(csc2, csc) parallel(csc2) parallel(csc)*/
546: nvl(csc.item_cost,0) *onhand_qty onhand_value_b,
547: nvl(csc.item_cost,0) *intransit_qty intransit_value_b
548: FROM cst_item_costs csc
549: WHERE csc.organization_id = fact.organization_id
550: AND csc.inventory_item_id = fact.inventory_item_id
551: And csc.cost_type_id =1 )
552: WHERE ((fact.onhand_value_b is null and nvl(fact.onhand_qty,0) <> 0)