DBA Data[Home] [Help]

APPS.OPI_DBI_CURR_INV_EXP_PKG dependencies on MTL_PARAMETERS

Line 579: -- (1 = standard, else layered) from MTL_PARAMETERS.

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

Line 639: -- are determined from the process_enabled_flag = 'Y' from MTL_PARAMETERS.

635:
636: -- For process organizations, we use the get_opm_item_cost API to get
637: -- the cost as on the run date. We collect cost for the lot-controlled items
638: -- in MTL_ONHAND_QUANTITIES that belong to process organizations.These orgs
639: -- are determined from the process_enabled_flag = 'Y' from MTL_PARAMETERS.
640: --
641: INSERT /*+ append parallel (opi_dbi_curr_inv_exp_f) */
642: INTO opi_dbi_curr_inv_exp_f (
643: organization_id,

Line 771: mtl_parameters mp,

767: moq.subinventory_code
768: ) exp_qty,
769: mtl_system_items_b msi,
770: eni_oltp_item_star items,
771: mtl_parameters mp,
772: cst_item_costs cic,
773: cst_quantity_layers cql,
774: mtl_secondary_inventories subs
775: WHERE exp_qty.inventory_item_id = msi.inventory_item_id