DBA Data[Home] [Help]

APPS.OPI_DBI_CURR_INV_EXP_PKG dependencies on CST_ITEM_COSTS

Line 582: -- be obtained from the CST_ITEM_COSTS table. Since there are multiple

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
586: -- cost_type_id records. Hence the need to do an outer join on the

Line 772: cst_item_costs cic,

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
776: AND exp_qty.organization_id = msi.organization_id