[Home] [Help]
12: s_opi_schema VARCHAR2(30);
13: s_status VARCHAR2(30);
14: s_industry VARCHAR2(30);
15:
16: -- Package level variables for the standard who columns
17: s_user_id NUMBER;
18: s_login_id NUMBER;
19: s_program_id NUMBER;
20: s_program_login_id NUMBER;
575: -- ==> Lot has expired
576: --
577: -- Inventory value is computed using the current item costs stored in the
578: -- system. The cost type is determined from the primary_cost_method
579: -- (1 = standard, else layered) from MTL_PARAMETERS.
580: --
581: -- For standard costing organizations, the current item cost can
582: -- be obtained from the CST_ITEM_COSTS table. Since there are multiple
583: -- cost_type_id's in the CIC table, we care only about frozen cost
577: -- Inventory value is computed using the current item costs stored in the
578: -- system. The cost type is determined from the primary_cost_method
579: -- (1 = standard, else layered) from MTL_PARAMETERS.
580: --
581: -- For standard costing organizations, the current item cost can
582: -- be obtained from the CST_ITEM_COSTS table. Since there are multiple
583: -- cost_type_id's in the CIC table, we care only about frozen cost
584: -- (cost_type_id = 1). Also, CIC may not have a frozen (cost_type_id = 2)
585: -- record for a layered costing org item, but may have other
599: -- Similarly items in expense subinventories will be assigned 0 value.
600: --
601: -- Store the inventory value in the functional currency, DBI primary
602: -- global currency and DBI secondary global currency (if set up). Use
603: -- the standard fii_currency.get_global_rate_primary and
604: -- fii_currency.get_global_rate_secondary to get conversion rates.
605: --
606: -- Rates are only needed for all distinct organizations with defined lots
607: -- as of the day on which the program is being run.
721: OPI_DBI_INV_VALUE_INIT_PKG.GET_OPM_ITEM_COST(exp_qty.organization_id,
722: exp_qty.inventory_item_id,
723: p_run_date),
724: decode (mp.primary_cost_method,
725: C_STANDARD_COSTING_ORG,
726: cic.item_cost,
727: cql.item_cost))))))
728: onhand_val_b,
729: sum (decode (subs.asset_inventory,
735: OPI_DBI_INV_VALUE_INIT_PKG.GET_OPM_ITEM_COST(exp_qty.organization_id,
736: exp_qty.inventory_item_id,
737: p_run_date),
738: decode (mp.primary_cost_method,
739: C_STANDARD_COSTING_ORG,
740: cic.item_cost,
741: cql.item_cost))))))
742: expired_val_b
743: FROM