DBA Data[Home] [Help]

APPS.CST_TPRICE_PVT dependencies on CST_ITEM_COST_DETAILS

Line 479: /* Bug 3239084: use cst_item_cost_details from the costing org to support cost sharing */

475: -- If the sending org is standard costing, get costs from CIC, otherwise from MCACD
476: if (l_std_from_org <> 0) then
477: l_stmt_num := 190;
478:
479: /* Bug 3239084: use cst_item_cost_details from the costing org to support cost sharing */
480: SELECT sum(item_cost)
481: INTO l_elem_cost
482: FROM cst_item_cost_details
483: WHERE inventory_item_id = p_item_id

Line 482: FROM cst_item_cost_details

478:
479: /* Bug 3239084: use cst_item_cost_details from the costing org to support cost sharing */
480: SELECT sum(item_cost)
481: INTO l_elem_cost
482: FROM cst_item_cost_details
483: WHERE inventory_item_id = p_item_id
484: AND cost_element_id = l_cost_element
485: AND cost_type_id = 1
486: AND organization_id =