DBA Data[Home] [Help]

APPS.CTO_BOM_RTG_PK dependencies on CST_ITEM_COST_DETAILS

Line 2340: select sum(item_cost) into v_cto_cost_xudc from cst_item_cost_details

2336: and organization_id = p_cost_organization_id -- 3116778
2337: and cost_type_id = v_cto_cost_type_id ;
2338:
2339: lStmtNum := 32;
2340: select sum(item_cost) into v_cto_cost_xudc from cst_item_cost_details
2341: where inventory_item_id = pConfigId
2342: and organization_id = p_cost_organization_id -- 3116778
2343: and cost_type_id = v_cto_cost_type_id
2344: and rollup_source_type = 3 ; -- bugfix 2808704

Line 2397: from cst_item_cost_details

2393: /* check whether rolledup cost exists in frozen cost in standard costing org */
2394: if( v_primary_cost_method = 1) then
2395: begin
2396: select count(*) , sum(item_cost) into v_rolledup_cost_count, v_rolledup_cost
2397: from cst_item_cost_details
2398: where inventory_item_id = pConfigId
2399: and organization_id = p_cost_organization_id -- 3116778l
2400: and cost_type_id = v_primary_cost_method
2401: and rollup_source_type = 3 ;