DBA Data[Home] [Help]

APPS.CTO_BOM_RTG_PK dependencies on CST_ITEM_COST_DETAILS

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

2276: and organization_id = p_cost_organization_id -- 3116778
2277: and cost_type_id = v_cto_cost_type_id ;
2278:
2279: lStmtNum := 32;
2280: select sum(item_cost) into v_cto_cost_xudc from cst_item_cost_details
2281: where inventory_item_id = pConfigId
2282: and organization_id = p_cost_organization_id -- 3116778
2283: and cost_type_id = v_cto_cost_type_id
2284: and rollup_source_type = 3 ; -- bugfix 2808704

Line 2337: from cst_item_cost_details

2333: /* check whether rolledup cost exists in frozen cost in standard costing org */
2334: if( v_primary_cost_method = 1) then
2335: begin
2336: select count(*) , sum(item_cost) into v_rolledup_cost_count, v_rolledup_cost
2337: from cst_item_cost_details
2338: where inventory_item_id = pConfigId
2339: and organization_id = p_cost_organization_id -- 3116778l
2340: and cost_type_id = v_primary_cost_method
2341: and rollup_source_type = 3 ;