DBA Data[Home] [Help]

APPS.CSD_ESTIMATE_UTILS_PVT dependencies on CST_COST_TYPES

Line 986: FROM cst_item_costs a, cst_cost_types b

982: -- Cursor to get the item cost for a material item
983: -- Service validation org is considered here.
984: CURSOR CUR_MATERIAL_COST(p_item_id NUMBER) IS
985: SELECT item_cost item_cost
986: FROM cst_item_costs a, cst_cost_types b
987: WHERE a.cost_type_id = b.cost_type_id
988: AND UPPER(b.cost_type) = 'FROZEN'
989: AND a.inventory_item_id = p_item_id
990: AND a.organization_id = Cs_Std.GET_ITEM_VALDN_ORGZN_ID;