DBA Data[Home] [Help]

APPS.CST_INVENTORY_PVT dependencies on CST_ELEMENTAL_COSTS

Line 4091: -- Use the cost in cst_elemental_costs of that cost history

4087:
4088: -- if cost history prior that p_valuation_date found prior the p_valuation_date
4089: -- the l_inventory_item_id in that l_organization_id
4090: IF l_max_cost_update_id IS NOT NULL THEN
4091: -- Use the cost in cst_elemental_costs of that cost history
4092: INSERT
4093: INTO cst_inv_cost_temp(
4094: organization_id,
4095: inventory_item_id,

Line 4117: FROM cst_elemental_costs CEC,

4113: SUM(DECODE(CEC.cost_element_id,2,NVL(CEC.standard_cost,0),0)),
4114: SUM(DECODE(CEC.cost_element_id,3,NVL(CEC.standard_cost,0),0)),
4115: SUM(DECODE(CEC.cost_element_id,4,NVL(CEC.standard_cost,0),0)),
4116: SUM(DECODE(CEC.cost_element_id,5,NVL(CEC.standard_cost,0),0))
4117: FROM cst_elemental_costs CEC,
4118: mtl_parameters MP
4119: WHERE CEC.cost_update_id = l_max_cost_update_id
4120: AND MP.organization_id = l_organization_id
4121: AND CEC.organization_id = MP.cost_organization_id